System tables are internal tables that are not managed by the user.
You have to reload the system tables when you change the version of the database software. You do not need to reload system tables when you restore a database instance.
To load the system tables, the Database Manager needs to know the name and password of the SYSDBA user. Otherwise, enter this information along with the DBM commands for loading the system tables.
You have the server authorization ExecLoad or LoadSysTab.
load_systab [-u <sysdba_user>,<sysdba_user_password>]
OK<NL>
0,<description><NL>
<pgmcode>,<command><NL>
<loader_client_output_lines><NL>
<loader_client_log_lines><NL>
Values for the Reply Fields
Field |
Description |
<description> |
Descriptive text |
<pgmcode> |
Return value of the executed program |
<command> |
Command line executed by the DBM Server program |
<loader_cient_output_lines> |
Output text of the program |
<loader_client_log_lines> |
Lines of the LOAD log |
Example
Logging on to the Database Manager CLI as operator DBM with password DBM, connecting to the HOTELDB database instance, loading the system tables with authorization for this command as database user DBA with password DBA:
dbmcli –d HOTELDB –u DBM,DBM
dbmcli on HOTELDB>load_systab –u DBA,DBA
OK
0,OK: everything works fine
0,""c:\program files\sdb\7500\bin\x_python" "c:\program files\sdb\7500\env\lsyst
ab.py" -R "c:\program files\sdb\7500" -d HOTELDB -u dba,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
…
…