Background documentationauto_load_systab Locate this document in the navigation structure

 

With this command you can display whether the system tables used by the system are up-to-date. You can also display whether the automatic update function for the system tables is on or off, and you can switch the function on and off.

The system default value of the automatic update function for the system tables is ON.

If this function is on, the system checks, whether the version of the database software and the version of the system tables in the database are identical. This check is done during restart after the database has been transferred to the ONLINE operational state.

If the versions are not identical, the system automatically executes the command for updating the system tables (see also load_systab).

If you swith off this function, the automatic update for the system tables is only deactivated for the next restart. The system re-activates it automaticaly for the next but one restart.

Note Note

Only deactivate the automatic update function for the system tables if you are instructed to do so by technical support.

End of the note.

Prerequisites

Structure

auto_load_systab <option>

<option> :: = SHOW | OFF | ON

Options

Option

Description

ON

Switches on the function for automatically updating the system tables every time the database is started.

System default value

OFF

Switches off the function for automatically updating the system tables every time the database is started.

SHOW

Displaying the status of the function for automatically updating the system tables.

Result

OK

[Automatic loading of system tables is <ON | OFF>.]

[The system tables are <TOPICAL | OUTDATED>.]

Values for the Reply Fields

Value

Description

ON

The function for automatically updating the system tables is ON. The system tables are updated each time the database starts.

OFF

The function for automatically updating the system tables in OFF.

VALID

The 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.