Step 1—Modify default parameters (optional)

Modify the default parameters for operating tableBASE in a DB2 Stored Procedures environment, if desired. If the default values are acceptable or you wish to use the Override feature provided via the TBOPT dataset, no additional work is necessary in this step.

For parameter descriptions, see tableBASE run-time options. The default values for this component are listed below and are also defined in your.prefix.SRC(DK1T1434).

Default DB2 parameters

TBOPTGEN DB2,
            ALLOW_TB_LIB_IO=N, 
            DATERTNX=N,
            FGDELIM=*,
            HASH_HI_DEN_LIM=900,
            HASH_LOW_DEN_LIM=600,
            LISTOPTIONS=N,
            LOCKTIMERC=0,
            LOCKTIMEWTO=30,
            MAXNMTAB=0,
            MTRETAIN=N,
            OVRRIDES=YYYYYYYY,
            SWITCHES=NNYYNNNN,
            TABLEWAITRC=0,
            TABLEWAITWTO=30,
            TSR_ALGORITHM=D,
            TSR_WARNING_FREQ=1,
            TSR_WARNING_PCT=85,
            TSRSIZE=10M,
            USEREXITS=N,
            VTSFIRST=,
            VTSLAST=,
            VTSNAME=,
            VTSPREFIX=VTS:,
            ZEROROWS=Y,
            ML=MAINLIB

To make changes to the default parameters:

• Modify your.prefix.SRC(DK1T1434).
• Reassemble and link-edit the module into the tableBASE module DK1DBASE using your.prefix.CNTL(ALT1434) as a model.