When you use the BS2000 command INFORM-PROGRAM for administration, messages are sent to the DBH or SESDCN in the form of administration commands (STXIT routine). Replies are written to SYSLST and SYSOUT. For reasons of compatibility the earlier command SEND-MSG can also be used.
There are two ways to enter the administration commands:
at the terminal at which the DBH or SESDCN was started in interactive mode
at the console of the BS2000 system administrator.
The BS2000 STXIT routine restricts inputs to a length of 60 characters. You therefore have to abbreviate the keywords of some of the administration commands. No blanks may be entered between the syntax elements. All entries are automatically converted from lower to upper case.
An administration command sent to the SESAM-DBH can be distributed among several INFORM-PROGRAM commands. To do this, the entry of the INFORM-PROGRAM command to be continued must end with a comma. The next INFORM-PROGRAM command will then be interpreted as the continuation of the administration command. The administration command is only executed once the entire command entered is complete. This does not apply to SESDCN.
A job sent via the INFORM-PROGRAM interface is generally only approved once the SESAM/SQL-DBH system start has been completed (shown by outputting the message “SES0060 SYSTEM READY”). The same is true for SESAM-DCN (shown by outputting the message “SEN3020 SESDCN READY”).
The acknowledge is sent by the administration via INFORM-PROGRAM only after the job has been completely processes, i.e. the behavior is the same as for the administration when sent via the CALL-DML interface or via SESADM.
If an internal restart is triggered while an administration command is being processed, the command is aborted. It can happen in this case that the acknowledge is not sent although the command has already been executed. However, it may be that the command was not executed.
Entering commands at the terminal
If the DBH or SESDCN was started in interactive mode from the system administrator's terminal, you can enter the administration commands from this terminal.
To enter an administration command, proceed as follows:
Press the key [K2] or [EM] [DUE] thus interrupting the task of the DBH (independent DBH or linked-in application) or SESDCN.
Issue a INFORM-PROGRAM command to pass the administration command to the DBH or SESDCN task:
/INFORM-PROGRAM MSG='admin-cmd'Any quotes in the text of the administration command must be entered twice.
Because the DBH or SESDCN is interrupted for the command input and cannot continue working during this time, it is not advisable to enter an administration command at the terminal.
at the console of the BS2000 system administrator.
If the DBH or SESDCN was started in batch mode, you must enter the administration commands at the console of the BS2000 system administrator. You enter the INFORM-PROGRAM command as follows:
/INFORM-PROGRAM JOB-ID=*TSN(TSN=tsn),MSG='admin-cmd'
where:
| is the task sequence number of the task in which the independent DBH, linked-in |
Any quotes in the text of the administration command must be entered twice.
In addition, a user with the privilege OPERATING or TSOS can also administer DBHs or SESDCN via /INFORM-PROGRAM where the DBHs or SESDCN are started in the interactive mode from any terminal.
Outputs occurring during administration via INFORM-PROGRAM are made on the same terminal as the DBH messages according to the option MSG-OUTPUT.
Several concurrent STXIT routines
One INFORM-PROGRAM command can activate several STXIT routines concurrently. In the case of the linked-in DBH, for example, STXIT routines of both the DBH and the application program can be started.
When there are several concurrently active STXIT routines, you can direct the INFORM-PROGRAM command at a specific component, such as the DBH:
/INFORM-PROGRAM JOB-ID=*TSN(TSN=tsn),MSG='component,admin-cmd'
where:
component | is the component to which the INFORM-PROGRAM command is to be | |
SES: | DBH-STXIT | |
S63: | SEDI63-STXIT | |
DCN: | SESDCN-STXIT | |
component is an optional entry for the administration of SES DCN and the independent DBH, but it is mandatory for the linked-in DBH.
Outputting successor responses
Large database configurations supply extensive outputs, e.g. in the inquiry commands. An output section (a so-called response) has a maximum size of 32000 bytes. Larger output volumes are output in multiple responses.
You can call successor responses in the DBH using the administration command NEXT.
Successor responses can occur in the following administration commands because one output section may not suffice:
USER,CATALOG | (DBH and DCN) |
USER,INACT | (DBH) |
USER,PR | (DBH and DCN) |
USER,SPACE | (DBH) |
USER,TA | (DBH and DCN) |
SPACE | (DBH) |
OPT,CDBC-INFO | (DBH) |
OPT,DBC-INFO | (DBH) |
In the case of the administration command HOLD-TA information about transactions is output in successor responses if transactions still exist.
In the case of the administration command STOP information about transactions is output in successor responses if PTC transactions, utility statements or lock sequences still exist. In this case the system is not terminated.