DBH options

DBH options parametrize the DBH and define the essential characteristics of a session. You can modify most of the DBH options during ongoing operation (with the exception of CONFIGURATON-NAME and DBH-NAME), see section “Administration statements for changing DBH options”.
You can save the current DBH options to a file and use them again in the next DBH session, see "SAVE-DBH-OPTIONS".

DBH options are subdivided into higher- and lower-level DBH options.

• Higher-level DBH options, such as ADMINISTRATION or STORAGE-SIZE, relate to a particular subject area.

• Lower-level DBH options each deal with part of the subject area of their higher-level option.

All the higher-level DBH options are assigned one or more lower-level options.

You enter the DBH options after entering the DBH start statement SET-DBH-OPTIONS.

There are default settings for all DBH options. Therefore, you only need to enter those options for which you want to specify values other than the defaults. However, before you can specify your own values for one or more lower-level options, you must first enter the associated higher-level option.

The following overview shows the DBH options that are available.

Overview of the DBH options

Higher-level option	Lower-level option	Brief description
DBH-IDENTIFICATION	CONFIGURATION-NAME DBH-NAME	Identifies the DBH Defines the configuration name Defines the DBH name
ADMINISTRATION	ACCOUNTING ADMINISTRATOR MSG-OUTPUT SECURITY	Administers the DBH Activates accounting Assigns administration authorization Controls the outputs of the DBH Changes security settings
CPU-RESOURCES	DBH-TASKS SERVICE-TASKS	Controls the CPU utilization Specifies the number of the DBH tasks Specifies the number of tasks for service requests
FILE-RESOURCES	MEDIA-CATALOG SESSION-LOGGING-ID	Specifies settings for files Creates a media catalog Identifies session-specific files
LINKED-IN- ATTRIBUTES	CODED-CHARACTER-SET	Specifies attributes of the linked-in DBH Specifies a coded character set which is used by the user program.
RECOVER-OPTIONS	SYSTEM-DATA-BUFFER USER-DATA-BUFFER MEDIA-CATALOG	Specifies settings for RECOVER or REFRESH runs Dimensions the system-data buffer Dimensions the user-data buffer Creates the media catalog
STORAGE-SIZE	CURSOR-BUFFER SYSTEM-DATA-BUFFER TRANSFER-CONTAINER USER-DATA-BUFFER WORK-CONTAINER	Creates buffer and container size Dimensions the cursor buffer Dimensions the system data buffer Dimensions the transfer container Dimensions the user data buffer Dimensions the work container
SYSTEM-LIMITS	COLUMNS OLD-TABLE-CATALOG SPACES SQL-DATABASE-CATALOG SQL-SUPPORT SUBORDERS SYSTEM-THREADS THREADS USERS	Specifies limit values Enlarges the area for retrieval statements Specifies the maximum number of entries permitted in the CALL DML table catalog Specifies the maximum number of simultaneously accessible spaces Specifies the maximum number of entries permitted in the SQL database catalog Specifies limit values for the SQL interface Makes SQL scans or logical files available Specifies the number of concurrent system threads Specifies the maximum number of concurrent threads Specifies the maximum number of concurrent users
SYSTEM STRATEGIES	REQUEST-CONTROL RESTART-CONTROL RETRIEVAL-CONTROL TRANSACTION-SECURITY	Defines the processing strategy Activates priority control Controls the duration of availability in the event of a restart Influences the search strategy of the DBH Activates transaction management