Administration statements for changing DBH options

There are three categories of administration statements for changing DBH options in the ongoing DBH session:

1. Some administration statements change DBH options which have no influence on the storage structure and mode of operation of the DBH.

2. The administration statement RECONFIGURE-DBH-SESSION reconfigures the ongoing DBH session and changes the following DBH options:

   • COLUMNS

   • CURSOR-BUFFER

   • SPACES

   • SQL-SUPPORT (CURSORS and PLANS operands)

   • SYSTEM-DATA-BUFFER

   • TRANSACTION-SECURITY (MAX-ISOLATION-LEVEL operand)

   • USER-DATA-BUFFER

3. The administration statement RELOAD-DBH-SESSION reloads the DBH modules, reconfigures the DBH session and, if required, changes the following DBH options:

   • DBH-TASKS

   • SYSTEM-THREADS

   • THREADS

   • USERS

The change to the DBH options is optional.

The table below shows which options can be changed with which administration statement.

Higher-level option	Lower-level option Operand	Administration statement to change it
ADMINISTRATION	ADMINISTRATOR MSG-OUTPUT SECURITY	MODIFY-ADMINISTRATION MODIFY-MSG-OUTPUT MODIFY-SECURITY
CPU-RESOURCES	DBH-TASKS SERVICE-TASKS	RELOAD-DBH-SESSION MODIFY-SERVICE-TASKS
FILE-RESOURCES	SESSION-LOGGING-ID	MODIFY-SESSION-LOGGING-ID
RECOVER-OPTIONS		MODIFY-RECOVER-OPTIONS
STORAGE-SIZE	CURSOR-BUFFER TRANSFER-CONTAINER WORK-CONTAINER SYSTEM-DATA-BUFFER USER-DATA-BUFFER	RECONFIGURE-DBH-SESSION MODIFY-STORAGE-SIZE MODIFY-STORAGE-SIZE RECONFIGURE-DBH-SESSION RECONFIGURE-DBH-SESSION
SYSTEM-LIMITS	COLUMNS OLD-TABLE-CATALOG SPACES SQL-SUPPORT INACTIVITY-TIME CURSORS INTERNAL-SORT-LIMIT PLANS SUBORDERS MAXIMUM SYSTEM-THREADS THREADS USERS	RECONFIGURE-DBH-SESSION MODIFY-OLD-TABLE-CATALOG-LIMIT RECONFIGURE-DBH-SESSION SET-USER-INACTIVE-TIME RECONFIGURE-DBH-SESSION MODIFY-SQL-SORT-LIMIT RECONFIGURE-DBH-SESSION MODIFY-SUBORDER-LIMIT RELOAD-DBH-SESSION RELOAD-DBH-SESSION RELOAD-DBH-SESSION
SYSTEM-STRATEGIES	REQUEST-CONTROL QUEUE-RANGE QUEUE-PRIORITY RESTART-CONTROL TALOG-LIMIT SYSTEM-DATA-BUFFER-LIMIT USER-DATA-BUFFER-LIMIT RETRIEVAL-CONTROL INDEX-EVALUATION USER-DATA-ACCESS ABORT-EXECUTION TRANSACTION-SECURITY LOCK-TIME INACT-TIME MAX-ISOLATION-LEVEL LOCK-ESCALATION	MODIFY-REQUEST-CONTROL MODIFY-REQUEST-CONTROL MODIFY-REQUEST-CONTROL MODIFY RESTART-CONTROL MODIFY RESTART-CONTROL MODIFY RESTART-CONTROL MODIFY-RETRIEVAL-CONTROL MODIFY-RETRIEVAL-CONTROL MODIFY-RETRIEVAL-CONTROL MODIFY-TRANSACTION-SECURITY MODIFY-TRANSACTION-SECURITY RECONFIGURE-DBH-SESSION MODIFY-TRANSACTION-SECURITY