Global LST parameters for BQL

Parameter name

Value

Description

Option

Default

BQL_GROUPS

1..9

To obtain a higher level of parallel processing in an STC, you can specify a maximum of nine BQL groups. Five groups is recommended.

Note: This parameter has no effect on batch jobs. Batch jobs always work with one BQL group.

optional

1

BQL_FUNCTION

nnn

Specifies the number of functions that can work in parallel within a group.

 

999

BQL_MASTER_SSID

ssid

Specifies the master system. In a master-slave system on one LPAR, or in an OCF/ XCF connection, this parameter must always be specified on the slave with the SSID of the master system. This does not apply if you are using a shared database (see "Sharing databases with the BQL share option").

optional

None

BQL_SHARE_OPTION

NO | SPOOL | ALL

Enables you to activate or deactivate the BQL share option.

optional

NO

BQL_OPEN_FILES

YES | NO

This parameter applies to _beta doc|z plus only:

If NO is specified, the SPOOL, CACHE, and INDEX files will not be opened until they are needed for the first time, i.e. they will not be automatically allocated and opened when the started task is started.

Note: The files concerned must be set to a specific status for this parameter to take effect. Please contact Beta Systems support for details.

optional

NO

BQL_INDEX_ CACHEBUFFER

nnnnn

You can specify the index files for _beta doc|z plus. nnnnn indicates the number of buffers (in 4K blocks) to be used. If the value specified here is > 30000, and A2G_SUPPORT=YES has not been set, the value will be reset to 30000.

optional

0

BQL_SPEEDMASTER

YES | NO

YES specifies that the BQL Speedmaster function is to be used for all DATA and KEY files. You can define the number of buffers for each file in the database definition file.

Important: Do not change the value of this parameter to NO. Otherwise serious performance problems could occur.

Exception: You have to set this parameter temporarily to NO following the occurrence of message 9502E or 9503W. For more information, see "Operator Response" of message 9502E and 9503W in BSA Messages and Codes.

optional

YES

BQL_SPOOLCHECK

YES | NO

YES

The master STC checks all spool blocks at startup and internal control blocks are built. Unused reader blocks are freed.

NO

There is no spool check at startup, which reduces the start phase of the master STC considerably.

Read-only spool files are always checked at startup, irrespective of the value of this parameter.

optional

NO

BQL_STATISTIC

YES | NO

The BQL statistics functionality can be switched on and off. When a started task or batch job is stopped, the values found for tables and commands will be written.

optional

NO

BQL_QRY_ MAXMEMORY

0..2000

Central storage (amount in MB)

Use this keyword to specify how much central storage is to be used for database queries online (online option D.Q). Specify 0 to use DASD storage instead of central storage.

Note: If both BQL_QRY_MAXMEMORY and BQL_QRY_FILESPACE are set to 0, unlimited central storage is used.

optional

If VDF:
2

If TSO:
2000

BQL_QRY_FILESPACE

0..2000

DASD storage (amount in cyls)

Use this keyword to specify how much file space is to be used on a temporary DASD for database queries online (online option D.Q). Specify 0 to use central storage instead of DASD storage.

optional

50

BQL_DICT_FLAG_ SEARCH

YES | NO

By default, option D.2.3 (FIELDS) includes subfield information (so-called flag fields) in the displayed table. If you don't need this information, you can disable this function to reduce resource consumption if the number of flag fields used by the product is very high (for example _beta access). This parameter can be updated dynamically via the Service Manager.

optional

YES

BQL_TRACE

YES | NO

YES causes the logging of all BQL and BOF commands

optional

NO

BQL_USER

number of users

This keyword specifies the number of users allowed in the internal RACF security user table of BQL. 0 means that the internal security table will not be used. When you increase or decrease the number of users, refresh the table with the following MODIFY command for your change to take effect:

F stcname,REFRESH RCF[,U=userid]

For more information, see "Refreshing the RACF security user table".

optional

500