Administration statements and commands are available to you for dynamic administration:
DBH-specific administration statements and commands allow you to monitor and influence the DBH session. You can also modify a large number of DBH options during ongoing operation, see for example "MODIFY-MSG-OUTPUT". You can save the current DBH options to a file and use them again in the next DBH session, see "SAVE-DBH-OPTIONS".
In distributed processing with SESAM/SQL-DCN, SESDCN-specific administration statements and commands allow you to administer the SESDCN distribution component.
Most administration statements and commands take effect immediately they are issued. With some of them there may be a wait until the required resources are available.
Depending on the interface you use for administration, you issue administration statements or administration commands.
Administration statements are for administration with SESADM. Their syntax complies with SDF syntax rules (e.g. SHOW-INACTIVE-SQL-USERS). They can be abbreviated in accordance with SDF conventions.
When you carry out administration using INFORM-PROGRAM or a CALL DML program, you use administration commands, whose syntax is not subject to SDF rules (e.g. USER,INACT).
Administration statements and administration commands offer the same functionality.
The following sections briefly describe the syntax and functions of the administration statements. You will find a list of administration statements and the equivalent commands as of "Equivalent administration statements and commands".
Peculiarity of the linked-in DBH
You have to use administration commands to administer the linked-in DBH with INFORM-PROGRAM or an integrated CALL DML program. It is not possible to use SESADM to administer the linked-in DBH.
An administration command to the linked-in DBH is not processed until the next statement is issued in the application program and control is thus passed to the DBH. In contrast, administration statements and commands to the independent DBH are processed immediately.