Previous Topic: Origins of TILTAB50Next Topic: Tasks to Define Installation Variables


How TILTAB50 Is Used

While creating installation JCL and SQL, the space parameters in TILTAB50 become input to CEJOB02 for VSAM and to SQL CRNEWSP and CRNEWIX used by CEJOB04 for Storage Groups.

The following is a sample DB2 DDL used to create CA Gen DASC Table:

CREATE TABLESPACE DASC
     IN GEND
 USING STOGROUP STO03 (STO03=Storage Group Table DASC)
PRIQTY 19200             (Primary Space in 1K records)
SECQTY 9600              (Secondary Space in 1K records)
LOCKSIZE ANY
SEGSIZE 64

The following is a sample VSAM JCL of CA Gen DASC Table:

DEFINE CLUSTER +
(NAME('AACC2.DSNDBC.GEN.DASC.I0001.A001') +
LINEAR +
REUSE +
VOL(BDS001) +          (BDS001 is VSAM data set volume)
RECORDS(4800 2400) +   (4800=primary space, 2400=secondary space in 4K pages)
SHR(3,3) ) +         
DATA +
(NAME('AACC2.DSNDBD.GEN.DASC.I0001.A001'))