load_systab

Use

System tables are internal tables of the system that users do not define or change.

To load 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.

After you have installed a new version of the database software and transferred the database instance to this version (that is, upgraded it), you need to reload the system tables.

You do not need to reload system tables when restoring a database instance normally. If you are making a copy of the database however and have thus restored the data backup for database instance A in a database instance B then you need to finish off by loading the system tables. To do this, you require the data of the database system administrator stored in the data backup that has been imported.

See also:

Glossary, System Table

Prerequisites

?     You have the server authorization ExecLoad or LoadSysTab.

?     The database instance is in the ONLINE operational state:

Syntax

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

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

Reply

OK

0,<err_description>

<loader_code>,<dbm_command>

<loader_output_lines>

<loader_log_lines>

Values for the Reply Fields

Field

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, authorization for this DBM command 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

...

...