UPDATE STATISTICS

z/OS JCL › Utility Statements › UPDATE STATISTICS

UPDATE STATISTICS

DD statements for the batch command facility (z/OS)

//userdb   DD  DSN=user.userdb,DISP=SHR

Additional database file assignments, as required

//ddlcat   DD  DSN=sysdict.ddlcat,DISP=OLD
//ddlxcat  DD  DSN=sysdict.ddlxcat,DISP=OLD
//j1jrnl   DD  DSN=tape.j1jrnl,DISP=(NEW,disp)

Additional journal file assignments, as required

userdb	DDname of the database file
user.userdb	Data set name of the database file
ddlcat	DDname of the database file containing the area of the system dictionary with the table definitions
sysdict.ddlcat	Data set name of the database file containing the area of the system dictionary with the table definitions
ddlxcat	DDname of the database file containing the area of the system dictionary with indexes
sysdict.ddlxcat	Data set name of the database file containing the area of the system dictionary with indexes
j1jrnl	DDname of the first journal file, as defined in the DMCL
tape.j1jrnl	Data set name of the first journal file
disp	The disposition of the first journal file

Central version

To execute UPDATE STATISTICS under the central version, modify the previous JCL as follows:

Optionally remove any journal and database DD statements.

Insert the following statement:

//SYSCTL   DD  DSN=idms.sysctl,DISP=SHR

sysctl	DDname of the SYSCTL file
idms.sysctl	Data set name of the SYSCTL file