load_systab

You can use this command to update the system tables.

Note Note

You do not need to exeute this command for normal database operation, as the database system has a function for automatically updating the system tables; according to the default value, this function is switched on (see auto_load_systab). This means that the system checks whether the system tables need to be updated every time the database instance is started. If this is the case, the system updates the system tables.

End of the note.

You can use this command, for example, to restore system table entries that have been deleted accidentally, without having to stop and restart the database system. In the event of a support intervention, it may be necessary for you to execute this command.

To update the system tables, the Database Manager needs to know the name and password of the database system administrator. If this is not the case, enter this information along with the DBM command for loading the system tables.

Prerequisites

You have the server authorization ExecLoad or LoadSysTab.
The database instance is in the ONLINE operational state:

Structure

load_systab [-u <sysdba_user>,<sysdba_user_password>]

Options
Option	Description
`<sysdba_user>`	Name of the database system administrator of the database instance from which the imported data backup originates
`<sysdba_user_password>`	Password of the database system administrator

Result

OK

0,<err_description>

<loader_code>,<dbm_command>

<loader_output_lines>

<loader_log_lines>

Values for the Reply Fields
Value	Description
`<err_description>`	Message text
`<loader_code>`	Return code from Loader
`<dbm_command>`	DBM command executed
`<loader_output_lines>`	Loader message text
`<loader_log_lines>`	Content summary of Loader log

Example

Call the Database Manager CLI in session mode, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB:

>dbmcli –d DEMODB –u OLEG,MONDAY

dbmcli on DEMODB>

Load the system tables for this DBM command,; authorization as the database system administrator DBADMIN with password SECRET:

dbmcli on DEMODB>load_systab –u DBADMIN,SECRET

OK

0,OK: everything works fine

0,""c:\program files\sdb\demodb\bin\x_python" "c:\program files\sdb\demodb\env

\lsystab.py" -R "c:\program files\sdb\demodb" -d DEMODB -u OLEG,*"

Removing obsolete objects

Installing Loader tables

Installing messages and help

Installing SYSDBA tables

Installing comments for SYSDBA tables

Installing precompiler tables

Installing system tables for R3 backup information

Installing ODBC tables

...

More Information

SQL Reference Manual, Syntax Tables