auto_load_systab 
You can use this command to display whether the system is using the current system tables. You can also display whether the automatic update function for the system tables is switched on or off, and you can switch the function on and off.
The automatic update function for the system tables is active by default.
If this function is on, the system checks during restart after the database has been transferred to the ONLINE operational state, whether the version of the database software and the version of the system tables in the database are identical. If this is not the case, the system automatically executes the command for updating the system tables (see also load_systab).
If you swith off this function, the automatic update function for the system tables is deactivated for the next restart only. It is automatically re-activated by the system for the next but one restart.
Note
Deactivate the automatic update function for the system tables only if you are instructed to do so by the support desk.
Prerequisites
Structure
auto_load_systab <option>
<option> :: = SHOW | OFF | ON
Option |
Description |
|---|---|
ON |
System default value The function for automatically loading the system tables every time the database instance is started is switched on. |
OFF |
The function for automatically loading the system tables is switched off. |
SHOW |
Displaying the function for automatically loading the system tables. |
Result
OK
[Automatic loading of system tables is <ON | OFF>.]
[The system tables are <TOPICAL | OUTDATED>.]
Value |
Description |
|---|---|
ON |
You have activated the function for automatically updating the system tables. The system tables are updated each time the database instance starts. |
OFF |
You have deactivated the function for automatically updating the system tables. |
VALID |
System tables are up to date. The contents are known to the system. |
INVALID |
The system tables have been changed. The changes are not yet known to the system. |
In the event of errors, see Reply Format.