load_systab

With this command you can 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.

As per the default value, this function is on (see auto_load_systab). This means that the system checks whether the system tables need to be updated every time the database is started. If this is the case, the system updates the system tables.

End of the note.

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

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

Prerequisites

You have the server permission ExecLoad or LoadSysTab.
The database 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
`<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 the Loader log

Example

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

>dbmcli –d DEMODB –u OLEG,MONDAY

dbmcli on DEMODB>

Enter the name DBADMIN and the password SECRET of the database system administrator an load the system tables:

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