tableBASE run-time options

This table lists the tableBASE run-time option parameters. Most occur in all interfaces. Options can be customized for your site at installation time using the TBOPTGEN macro in DK1Txx34 modules. Applications can further override options on an individual basis using the TBOPT dataset (DDNAME=TBOPT).

Table 113. Default option overrides

Parameter

Description

Default †

ALLOW_TB_LIB_IO

Allow tableBASE Library I/O – Allows access to tableBASE libraries.

Batch, CICS and IMS interfaces: Y;

DB2 SP interface: N

CICSJRNL

CICS Journal File ID (CICS only) – Specifies the CICS journal file number if strobe records are written.

99

DATERTNX

Date-Sensitive Processing Found Code – Specifies whether X is to be returned as a Found Code.

N

FGDELIM

Fetch Generic Delimiter – Specifies the wildcard value used for the Fetch Generic command.

*

HASH_HI_DEN_LIM

High Density Limit for Hash Indexes – Upper density limit for hash tables opened starting with Version 6.

900

HASH_LOW_DEN_LIM

Low Density Limit for Hash Indexes – Lower density limit for hash tables opened starting with Version 6.

600

LDS

Linear Data Set Use – Specifies whether the VTS-TSR defined in this jobstep will be mapped to an LDS. VTS Manager only.

N

LIBnn, ML

tableBASELibrary List – Default library names for a tableBASE Library List (LIB-LIST).

LIB00=MAINLIB

LISTOPTIONS

List Parameter Options – Specifies whether to list execution time parameters.

N

LOCKTIMERC

Lock Timer Wait Value – Specifies # of seconds that tableBASE should wait for a lock (0= wait indefinitely).

0

LOCKTIMEWTO

Lock Timer Message Wait Value – Number of seconds between messages indicating that the transaction is waiting for an internal lock (0=no message).

30

MAXNMTAB

Maximum Number of Tables – Specifies the maximum number of open tables allowed in the TSR. VTSNMTAB is maintained for backwards compatibility.

Depends on TSR size – see Programming Guide for details

MTRETAIN

Retain Rows and Index Areas – Determines whether the allocated row and index areas are to be retained when an MT command is issued.

N

MULTITASKING

Multitasking Option (Batch only) – Specifies whether this region will allow multiple subtasks to access tableBASE.

N

MULTOPNX

Multiple Alternate Index – This option is maintained for compatibility with previous releases, and is not used starting with tableBASE Version 6.

Y

OVRRIDES

Allow Changes To Status Switches – Specifies whether the user can change specific Status Switches at run time. Positional (see below) Y or N settings.

YYYYY batch, IMS, DB2

YNYYY CICS

RACF_LIBACCESS

Perform Checks on Protected Libraries – Specifies whether tableBASE should check if a tableBASE library is SAF interface protected.

N

RACF_VTS

Perform Checks on SAF Interface Protected VTS-TSRs – Specifies whether tableBASE should check if a VTS-TSR is SAF interface protected. Available only with VTS Gate.

N

STROBE

Strobe Interval – Specifies frequency of strobe records (in # of tableBASE calls or minute intervals).

0

STROBEMETHOD

Strobe Method – Specifies when tableBASE strobe reporting should be triggered for the VTS-TSR.

  1. 0, 1, 2 indicates that strobe should be triggered by number of tableBASE calls indicated by the STROBE option
  2. 3 indicates that strobe should be triggered by minute intervals indicated by the STROBE option

0

SUPPRESS_DUMPS

Suppress tableBASE messages and dumps – Specifies whether to suppress tableBASE messages and dumps when a transaction abends outside tableBASE code. Only for the CICS environment.

NONE

SWITCHES

Status Switches – Specifies status switch defaults (Y or N):

  1. whether to abend on tableBASE user errors (1-99; 1001-1099)
  2. whether to wait for tables that are opened for write
  3. whether to return empty rows from hash tables
  4. whether to automatically open tables on read accesses
  5. whether to trace last 10 tableBASE commands

YNYYN for batch/CICS

NNYYN for DB2/IMS

TABLEWAITRC

Table Open Enqueue Wait Time – Number of seconds tableBASE should wait for exclusive table enqueue (applies only if WAIT switch is on).

0

TABLEWAITWTO

Table Open Enqueue Report Time – Number of seconds between messages indicating that the transaction is waiting for an enqueue.

0

TPVM

VTS Group Manager use – Specifies a VTS Group Manager (TPVM) name to use for all accesses to VTS-TSRs.

compat

TSR_ALGORITHM

Optimize TSR Usage – Determines whether the Performance (P), or Default (D) attributes are predominant when allocating space in a TSR.

D

TSR_KEY_PROTECT

Hardware Key Protection for VTS-TSRs – Specifies whether a VTS-TSR is hardware key protected. Available only with VTS Gate. Any values from 1 to 7 indicates hardware key protection is on.

0

TSR_WARNING_FREQ

Frequency of TSR Allocation Warnings – Number of seconds between messages indicating the TSR is more than TSR_WARNING_PCT allocated.

0000

TSR_WARNING_PCT

Percentage of TSR Allocation for Warning Activation – Indicates percentage of TSR allocation allowed before a message is generated.

85%

TSRACCESS

Read Only or Read Write TSR Access – Specifies whether a VTS-TSR is Read-Only or Read/Write. Available only with VTS Gate.

RW

TSRSIZE

tableSPACE Region Size – Specifies the size of Data Space to be allocated for open tables for a region. TSREGION and TSR are maintained for backwards compatibility.

10M

USEREXITS

User Exits – Specifies whether User Exits are used ( Y|N ).

N

VTSFIRST

VTS Search Sequence – VTS-TSR to search before LIB-LIST (VTS only).

(null strings)

VTSLAST

VTS Search Sequence – VTS-TSR to search after LIB-LIST (VTS only).

(null strings)

VTSNAME

Specifying the Name of a VTS-TSR

  1. Specifies the name of a Shared TSR (VTS-TSR).
  2. Specifies the VTS-TSR name used by TBASE/TBCALLV interfaces.
  1. DKL1

VTSPREFIX

VTS Prefix Definition – Specifies a prefix that will be used by tableBASE to denote a VTS name within the ML list. There can be 0-3 characters before the colon; the colon is mandatory.

VTS:

ZEROROWS

Zero Data Table Rows on De-allocation – Determines whether the data rows area should be zeroed when table space in a TSR is deallocated.

Y

† The default settings listed here are delivered defaults of tableBASE from DataKinetics. Your site may have set the installation defaults differently.