DBH administration statements

The DBH administration statements are divided up into three tables as follows:

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

• The table 16 contains all administration statements that display or change the DBH start statements and options issued.

• The table 17 contains all other statements that can be used to control the DBH session.

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 requests of selected users
SHOW-CATALOG-USERS	Displays the number of active users within a TA for selected databases
SHOW-INACTIVE-SQL-USERS	Displays all inactive SQL users
SHOW-SPACE-USERS	Displays all active users of a selected space within a TA 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 15: 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
ADD-SQL-DB-CATALOG-ENTRY	Adds an entry to the SQL database catalog
MODIFY-ADMINISTRATION	Changes the administration authorization
MODIFY-CATALOG-ACCESS-RIGHTS	Changes the access rights for the specified database
MODIFY-MAIL-PARAMETERS	Changes the parameters for the email output of the DBH
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-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 retrieval statements
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-SQL-SORT-LIMIT	Changes the limit value for the number of sort records found in a cursor table
MODIFY-STORAGE-SIZE	Changes the maximum size of transfer and work containers
MODIFY-SUBORDER-LIMIT	Changes the limit value for the maximum number of SQL scans and/or logical files of CALL DML requests
MODIFY-TRANSACTION-SECURITY	Changes the transaction security parameters
RECONFIGURE-DBH-SESSION	Changes DBH options dynamically
RELOAD-DBH-SESSION	Reloads DBH modules and changes DBH options
REMOVE-OLD-TABLE-CATALOG- ENTRY	Removes an entry from the CALL DML table catalog
REMOVE-SQL-DB-CATALOG-ENTRY	Removes an entry from the SQL database catalog
REUSE-OLD-TABLE-CATALOG-ENTRY	Create valid reference to an existing table entry in the CALL DML table catalog
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-MAIL-PARAMETERS	Outputs parameters for the email output of the DBH
SHOW-OLD-TABLE-CATALOG-ENTRIES	Displays the entries in the CALL DML table catalog
SHOW-PARTITIONS	Displays the availability of partitions
SHOW-SQL-DB-CATALOG-ENTRIES	Displays the entries in the SQL database catalog

Table 16: 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	Close user space physically
COMMIT-PTC-TRANSACTION	Commits a PREPARE-TO-COMMIT transaction
CREATE-DUMP	Creates a main-memory dump
CREATE-SERVICE-TASK-DUMP	Creates a main-memory dump of a service task
END-FOREIGN-COPY	Cancel “copy pending” state on spaces after foreign copy. Changes the database status after PREPARE- FOREIGN-COPY with physical closure of the database files.
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-SAT-SUPPORT	Controls the logging of security relevant events with SAT
SET-SESSION-DIAGNOSIS	Display for controlling the 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 17: Other DBH administration statements that control database operation