Administration statements and commands

Administration statements and commands are available that allow system administrators to intervene in active operations:

• DBH-specific administration statements and commands allow system administrators to administer the DBH session.

• During distributed processing based on SESAM/SQL-DCN ), system administrators can use SESDCN-specific administration statements and commands to administer the distribution component SESDCN.

If system administrators require specific information on database operations, they can run the SESAM/SQL utility SESMON. SESMON's DBH statistics provide information that system administrators can use to monitor the DBH session and determine optimum settings for the DBH options. The SESDCN statistics provide information SESDCN operations (see section “Outputting operational data with SESMON” ).

Entering administration statements and commands

The administration statements and commands can be entered by the following means:

• through the administration program SESADM, which runs as a process in its own right, but which can also be accessed as a subroutine of the utility monitor

• through the BS2000 command INFORM-PROGRAM

• through CALL DML statements in a CALL DML program.

You can also access the administration program SESADM from the World Wide Web.
SESADM operation is described in the “Database Operation” manual.

Input format

Depending on the interface through which administration is to take place, system administrators must use administration statements or administration commands.

• Administration statements are for administration with SESADM. The administration program SESADM reads the input through the SDF dialog interface. Administration statement syntax therefore complies with SDF rules (e.g. SHOW-INACTIVE-SQL-USERS).

• When performing administration tasks using INFORM-PROGRAM or within a CALL DML program, administration commands in ISP format (e.g. USER,INACT) are available to the system administrator.

Administration statements offer an almost identical functional scope to administration commands. For this reason, only administration statements are described in the following overviews. Refer to the “Database Operation” manual for a brief description of the relevant administration commands.

Output of administration statements and commands

Large database configurations also supply extensive outputs, e.g. in the SHOW statements of SESADM. The statement MODIFY-OUTPUT-MODE in the DBH and DCN menus enables you to direct the output of administration statements to SYSOUT/SYSLST or to a temporary file.
The information outputs of most SHOW statements can be output in S variables and processed further in S procedures.

Under SESADM all outputs are complete. In the event of administration using INFORM-PROGRAM or a CALL-DML program an output section (a so-called response) has a maximum size of 32000 Byte. Larger output volumes are output in multiple responses. You can call the successor responses using the administration command NEXT.

Result of the administration statements

In interactive mode status messages and error messages are sent to SYSOUT and SYSLST, and in batch mode to the console and SYSLST. In addition, the message number of the last response of the DBH or of SESDCN to an administration statement is recorded in the S variable SESAM-RESULT and in the job variable #SESAM.SESADM.JV. This permits automatic administration with SESADM. See the “Database Operation”.

DBH administration statements

The tables below provide an overview of the DBH administration statements.

A detailed description of the syntax and meaning of the DBH administration statements is provided in the “Database Operation” manual. The manual also matches administration statements with equivalent administration commands.

The three tables are divided up as follows:

• The table 62 describes all administration statements that provide user-specific information.

• The table 63 contains all administration statements that display or change the DBH start statements and options issued (see section “Controlling and monitoring the session” ).

• The table 64 contains all other statements that can be used to control the SESAM/SQL operation.

Administration statement	Brief description
SHOW-USER-SPACES	Displays the spaces used by the user and thus locked
SHOW-CALL-DML-SUBORDERS	Displays the number of active CALL DML OPEN requests of selected users
SHOW-CATALOG-USERS	Displays the number of active users of selected databases
SHOW-INACTIVE-SQL-USERS	Displays all inactive SQL users
SHOW-SPACE-USERS	Displays all active users of a selected space together with relevant additional information
SHOW-TRANSACTIONS	Displays all open transactions of selected users with relevant additional information
SHOW-USERS	Displays all active users together with relevant additional information
SHOW-CATID-LIST	Displays the current CATID list

Table 62: DBH administration statements for user-specific information

Administration statement	Brief description
ADD-OLD-TABLE-CATALOG-ENTRY	Adds an entry to the CALL DML table catalog list
ADD-SQL-DB-CATALOG-ENTRY	Adds an entry to the SQL database catalog list
MODIFY-ADMINISTRATION	Changes the administration authorization
MODIFY-CATALOG-ACCESS-RIGHTS	Changes the access rights for the specified database
MODIFY-REQUEST-CONTROL	Changes the parameters for priority control
MODIFY-RESTART-CONTROL	Influences the duration of any restart
MODIFY-RETRIEVAL-CONTROL	Changes the criterion for interrupting or canceling retrieval statements
MODIFY-SQL-SORT-LIMIT	Changes the limit value for the number of sort records found in a cursor table
MODIFY-SUBORDER-LIMIT	Changes the limit value for the maximum number of SQL scans and/or logical files of CALL DML requests
MODIFY-MSG-OUTPUT	Changes the DBH output
MODIFY-OLD-TABLE-CATALOG-LIMIT	Changes the maximum number of entries in the CALL- DML table catalog
MODIFY-RECOVER-OPTIONS	Changes the options for subsequent RECOVER or REFRESH runs
MODIFY-SECURITY	Changes the maximum permissible number of password violations
MODIFY-SERVICE-TASKS	Changes the number and attributes of service tasks
MODIFY-SESSION-LOGGING-ID	Changes the identification of session-related files
MODIFY-STORAGE-SIZE	Changes the maximum size of transfer and work containers
MODIFY-TRANSACTION-SECURITY	Changes the transaction security parameters
RECONFIGURE-DBH-SESSION	Changes DBH options dynamically
RELOAD-DBH-SESSION	Reloads DBH modules
REMOVE-OLD-TABLE-CATALOG- ENTRY	Removes an entry from the CALL DML table catalog list
REMOVE-SQL-DB-CATALOG-ENTRY	Removes an entry from the SQL database catalog list
REUSE-OLD-TABLE-CATALOG-ENTRY	Creates a valid reference to an already existing table entry in the CALL DML database catalog list
REUSE-PARTITIONS	Restores the availability of partitions
SAVE-DBH-OPTIONS	Saves the current DBH options
SET-ACCOUNTING-PARAMETER	Controls logging of request accounting for the RAV procedure
SET-REQUEST-CONTROL	Turns priority control on and off
SET-USER-INACTIVE-TIME	Sets a time period after which a user's open but inactive transactions are rolled back
SHOW-DBH-MEDIA-CATALOG	Displays the currently valid DBH option MEDIA- CATALOG
SHOW-DBH-OPTIONS	Displays the currently valid DBH options except for MEDIA CATALOG
SHOW-OLD-TABLE-CATALOG- ENTRIES	Displays the entries in the CALL DML table catalog list
SHOW-PARTITIONS	Displays the availability of partitions
SHOW-SQL-DB-CATALOG-ENTRIES	Displays the entries in the SQL database catalog

Table 63: Administration statements for DBH start statements and options

Administration statement	Brief description
ABORT-LOCK-SEQUENCE	Terminate lock sequence of another user
ASSIGN-SYSLST	Switches a SYSLST file
BEGIN-LOCK-SEQUENCE	Starts a lock sequence
CANCEL-STATEMENT	Cancels a DML statement
CHANGE-CATLOG	Switches a CAT-LOG file and DA-LOG files
CHANGE-DALOG	Switches DA-LOG files
CLOSE-SPACE	Closes user space physically
COMMIT-PTC-TRANSACTION	Commits a PREPARE-TO-COMMIT transaction
CREATE-DUMP	Creates a main-memory dump
END-FOREIGN-COPY	Removes the “copy pending” state from spaces after foreign copy.
END-LOCK-SEQUENCE	Terminate lock sequence
HOLD-TRANSACTION-ADMISSION	Suspends admission of further transactions
MODIFY-CATID-LIST	Updates the CATID list
PREPARE-FOREIGN-COPY	Closes a database in order to be able to create a foreign copy
RELEASE-USER-RESOURCES	Releases all a user's resources
RESUME-TRANSACTION-ADMISSION	Permits resumption of transaction admission
ROLLBACK-PTC-TRANSACTION	Rolls back a user's PREPARE-TO-COMMIT transaction
ROLLBACK-TRANSACTION	Rolls back a user's transaction
SET-DBH-MSG-TRACE	Controls the logging of DBH messages
SET-DIAGNOSIS-DUMP-PARAMETER	Controls the creation of a dump
SET-SESSION-DIAGNOSIS	Controls deadlock analysis
SET-SQL-DB-CATALOG-STATUS	Changes the status of a database
SET-TUNING-TRACE	Controls request logging
STOP-DBH	Terminates a DBH session

Table 64: Other DBH administration statements that control database operation

SESDCN administration statements

The following table provides an overview of all the administration statements that are available for the administration of SESDCN. A detailed description of the syntax and meaning of the DBH administration statements is provided in the “Database Operation” manual. Here you will find also the administration statements with the corresponding administration commands.

Administration statement	Brief description
ADD-DISTRIBUTION-RULE-ENTRY	Adds a database to the distribution rule
CREATE-DUMP	Creates a main-memory dump
HOLD-TRANSACTION-ADMISSION	Suspends admission of further transactions
HOLD-USER-ADMISSION	Suspends admission of further users
MODIFY-ADMINISTRATION	Changes the administration authorization
MODIFY-DISTRIBUTION-RULE-ENTRY	Changes the host name in the distribution rule
REMOVE-DISTRIBUTION-RULE-ENTRY	Removes a database entry or database entries from the distribution rule
RESUME-TRANSACTION-ADMISSION	Permits resumption of transaction admission
RESUME-USER-ADMISSION	Resumes admission of new users
ROLLBACK-TRANSACTION	Rolls back a user's transaction
SET-USER-CALL-TRACE	Controls the logging of the statements of selected users
SET-USER-MSG-TRACE	Controls the logging of SESAM messages of selected users
SHOW-DISTRIBUTION-RULE-ENTRIES	Displays active databases entered in the distribution rule
SHOW-TRANSACTIONS	Displays all open transactions of selected users with relevant additional information
SHOW-USERS	Displays all active users together with relevant additional information
STOP-DCN	Terminates SESDCN

Table 65: SESDCN administration statements