Utility Statements (z/OS)

This section lists the following utility statements:
idmscu19
This section lists the following utility statements:
ARCHIVE JOURNAL
DD statements for the batch command facility (z/OS)
//
j1jrnl
DD DSN=
idms.j1jrnl
,DISP=SHR //
j2jrnl
DD DSN=
idms.j2jrnl
,DISP=SHR
Additional journal file assignments, as required
//
archjrnl
DD DSN=
idms.archive
,DISP=(NEW,KEEP), // UNIT=
tape
,VOL=SER=
nnnnnn
//*NOTE: The blksize and lrecl are set by the //* blksize that is defined in the DMCL. //* The file record format is fixed.
Additional archive journal file assignments, as required
Name
Description
j1jrnl
DDname of the first disk journal file, as defined in the DMCL
idms.j1jrnl
Data set name of the first disk journal file
j2jrnl
DDname of the second disk journal file, as defined in the DMCL
idms.j2jrnl
Data set name of the second disk journal file
archjrnl
DDname of the tape archive file, as defined in the DMCL
idms.archive
Data set name of the tape archive file
tape
Symbolic device name of the tape archive file
nnnnnn
Volume serial number of the tape archive file
ARCHIVE LOG
DD statements for the batch command facility (z/OS)
//
dlogdb
DD DSN=
idms.dlogdb
,DISP=SHR //
dmsgdb
DD DSN=
idms.dmsgdb
,DISP=SHR //
sysjrnl
DD DUMMY //SYS002 DD DSN=
idms.archive
,DISP=(NEW,CATLG) // DCB=(RECFM=VB,LRECL=280,BLKSIZE=
bbbb
)
Name
Description
dlogdb
DDname of the system log area
idms.dlogdb
Data set name of the system log area
dmsgdb
DDname of the system message area
idms.dmsgdb
Data set name of the system message area
sysjrnl
DDname of the tape journal file defined in the DMCL module
idms.archive
Data set name of the archive log file
bbbb
Block size of the archive log file; must be greater than or equal to 284 (typically, equal to 4 plus a multiple of 280)
ARCHIVE TRACE
The CA IDMS installation media contains the following sample JCL (intended for demonstration purposes only):
  • ATRCJCL -- Contains a skeleton of the JCL required to run the ARCHIVE TRACE utility.
BACKUP
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Additional file assignments, as required
//SYS001 DD DSN=
user.bkpfile
,DISP=(NEW,PASS), // UNIT=
tapeout
,VOL=SER=
nnnnnn
, // DCB=(RECFM=VB,BLKSIZE=
bbbb
)
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
user.bkpfile
Data set name of the tape backup file
tapeout
Symbolic device name of the tape backup file
nnnnnnn
Volume serial number of the tape backup file
bbbb
Block size of the tape backup file. Must be as large as the smaller of:
The size of the largest page being backed up, plus 8
32,760
BUILD
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=
disp
//SYS002 DD DSN=
user.load
,DISP=OLD//SYS003 DD DSN=
user.build
,DISP=(NEW,PASS),UNIT=
tape
,// DCB=(RECFM=VB,LRECL=
rrr
,BLKSIZE=
bbb
)//SYSPCH DD DSN=&&
sortbuild
,DISP=(NEW,PASS),// UNIT=
disk
,SPACE=(TRK,1),DCB=BLKSIZE=80//SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
)) The SORTMSG and SORTWK
nn
files are only needed when performing a complete BUILD. Add additional SORTWK
nn
files as necessary.
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
user.load *
Data set name of the input (SYS002) file; for sizing information see discussion of SYS003 in LOAD
user.build *
Data set name of the output (SYS003) file; for sizing information see BUILD
tape
Symbolic device name of the SYS003 file
rrr
Record size of the SYS003 file
bbb
Block size of the SYS003 file
&&sortbuild
Data set name of the SYSPCH file
disk
Symbolic device name of the SYSPCH file
When running a complete BUILD, SYS002 and SYS003 must point to the
same
intermediate file. When running a stepped BUILD, SYS002 and SYS003 must point to a
different
intermediate file.
CLEANUP
DD statements for the batch command facility (z/OS)
//
sysjrnl
DD DSN=
idms.tapejrnl
,DISP=SHR//
userdb
DD DSN=
user.userdb
,DISP=SHR
Additional database file assignments, as required
Name
Description
sysjrnl
DDname of the tape journal file
idms.tapejrnl
Data set name of the tape journal file
userdb
DDname of the user database file
user.userdb
Data set name of the user database file
Central version
To execute CLEANUP SEGMENT under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
CONVERT CATALOG
DD statements for the batch command facility (z/OS)
//
ddlcat
DD DSN=
ucat.ddlcat
,DISP=OLD //
ddlcatx
DD DSN=
ucat.ddlcatx
,DISP=OLD //
j1jrnl
DD DSN=
tape.j1jrnl
,(NEW,disp)
Additional journal file assignments, as required.
Name
Description
ddlcat
DDname of the database file containing the DDLCAT area of the dictionary to be converted
ucat.ddlcat
Data set name of the database file containing the DDLCAT area of the dictionary to be converted
ddlcatx
DDname of the database file containing the DDLCATX area of the dictionary to be converted
ucat.ddlcatx
Data set name of the database file containing the DDLCATX area of the dictionary to be converted
j1jrnl
DDname of the first journal file, as defined in the DMCL
tape.j1jrnl
Data set name of the first journal file
disp
Disposition of the first journal file
Central version
To execute CONVERT CATALOG under the central version, modify the previous JCL as follows:
  • Optionally remove any journal and dictionary DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
CONVERT PAGE
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Additional database file DD statements as needed.
//
newdb
DD DSN=
user.newdb
,DISP=SHR
Additional new converted database file DD statements as needed.
Name
Description
userdb
DDname of the input database file
user.userdb
Data set name of the input database file
newdb
DDname of the output converted database file
user.newdb
Data set name of the output converted database file
EXPAND PAGE
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=OLD
Additional existing database file assignments, as required
//
xfile
DD DSN=
user.xbase
,DISP=(NEW,CATLG),UNIT=
disk
, // VOL=SER=
nnnnnn
,SPACE=(
expanded-database-size
)
Additional expanded database file assignments, as required
Name
Description
userdb
DDname of the existing database file (as specified by the FILE parameter)
user.userdb
Data set name of the existing database file
xfile
DDname of the expanded database file (as specified by the INTO parameter)
user.xbase
Data set name of the expanded database file
disk
Symbolic device name of the expanded database file
nnnnnn
Volume serial number of the expanded database file
expanded-database-size
Space allocation for the expanded database file
EXTRACT JOURNAL
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=
&.&archive.
,DISP=(OLD) //
extract
DD DSN=
jrnl.extract
,DISP=(NEW,CATLG),// DCB=(RECFM=VB,BLKSIZE=
bbbbb
),// UNIT=
nnnn
,VOL=SER=
nnnnnn
//SORTMSG DD SYSOUT=A//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn,nnn
))
Add additional SORTWKnn files as necessary
Name
Description
&.&archive.
Data set name of the complete archive or journal file. It may be on tape or disk and concatenated.
extract
DDname of the extract journal file. If you don't specify, it defaults to SYS002.
jrnl.extract
Data set name for the extract journal file
bbbbb
Block size of the extract journal file. Specify a size at least as large as the largest block size on the journal or archive files being processed.
FASTLOAD
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=
&.&sortunld.
,DISP=SHR //SYS002 DD DSN=
user.dbl001
,DISP=(OLD,DELETE) //SYS004 DD DSN=
user.dbl004
,DISP=(NEW,PASS),UNIT=tape004, // DCB=(RECFM=VB,LRECL=
rrr004
,BLKSIZE=
bbb004
) //SYS005 DD DSN=
user.dbl005
,DISP=(NEW,PASS),UNIT=tape005, // DCB=(RECFM=VB,LRECL=
rrr005
,BLKSIZE=
bbb005
) //SYS009 DD DSN=
user.dbl009
,DISP=(NEW,PASS),UNIT=tape009, // DCB=(RECFM=VB,LRECL=
rrr009
,BLKSIZE=
bbb009
) //SYS010 DD DSN=
user.dbl010
,DISP=(NEW,PASS),UNIT=tape010, // DCB=(RECFM=VB,LRECL=
rrr010
,,BLKSIZE=
bbb010
) //SYS011 DD DSN=
user.dbl011
,DISP=(NEW,PASS),UNIT=tape011, // DCB=(RECFM=VB,LRECL=
rrr011
,BLKSIZE=
bbb011
) //SYSPCH DD DSN=&&sortld,DISP=(NEW,PASS),UNIT=disk, // SPACE=(TRK,1),DCB=BLKSIZE=80 //RELDCTL DD DSN=
user.reldctl
,DISP=SHR,UNIT=nnnn, VOL=SER=nnnnnn, DCB=(RECFM=FB,LRECL=60,BLKSIZE=bbbctl) //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
Add additional SORTWKnn files as necessary
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Additional existing database files assignments, as required
Name
Description
&.&sortunld.
Data set name of the sort parameters created by IDMSTBLU
user.dbl001
Data set name of the file put out by the format program
user.dbl004
Data set name of the intermediate work file containing the output from SORT1
tape004
Symbolic device name of the SYS004 file
rrr004
Record size of the SYS004 file; should be the same as the record size for SYS001
bbb004
Block size of the SYS004 intermediate work file; should be the same as the block size for SYS001
user.dbl005
Data set name of the intermediate work file containing a control record and set membership information from IDMSDBL2
tape005
Symbolic device name of the SYS005 file
rrr005
Record size of the SYS005 file; for sizing information, see FASTLOAD
bbb005
Block size of the SYS005 intermediate work file; must be at least rrr005 plus four bytes
user.dbl009
Data set name of the intermediate work file containing the sorted contents of SYS005
tape009
Symbolic device name of the SYS009 file
rrr009
Record size of the SYS009 file; should be the same as rrr005
bbb009
Block size of the SYS009 intermediate work file; should be the same as bbb005
user.dbl010
Data set name of the intermediate work file containing pointer information from IDMSDBL3
tape010
Symbolic device name of the SYS010 file
rrr010
Record size of the SYS010 file; for sizing information, see FASTLOAD
bbb010
Block size of the SYS010 intermediate work file; must be at least 60 bytes (the size of the control record plus four bytes)
user.dbl011
Data set name of the intermediate work file containing sorted pointer information from SORT4
tape011
Symbolic device name of the SYS011 file
rrr011
Record size of the SYS011 file; should be the same as rrr010
bbb011
Block size of the SYS011 intermediate work file; should be the same as bbb010
&&sortld
Data set name of the SYSPCH file
disk
Symbolic device name of the SYSPCH file
user.reldctl
Data set name of the reload control file containing control and set information
bbbctl
Blocksize of the RELDCTL file. It should be a multiple of 60 with a maximum size of 32,760.
userdb
DDname of the database file
user.userdb
Data set name of the database file
FIX ARCHIVE
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=
idms.tjrnlold
,DISP=(OLD,PASS),UNIT=
tapein
//SYS002 DD DSN=
idms.tjrnlfix
,DISP=(NEW,PASS),UNIT=
tapeout
, // DCB=BLKSIZE=
bbbb
Name
Description
idms.tjrnlold
Data set name of the input tape journal file
tapein
Symbolic device name of the input tape journal file
idms.tjrnlfix
Data set name of the output tape journal file
tapeout
Symbolic device name of the output tape journal file
bbbb
Block size of the output tape journal file, as defined in the DMCL
FIX PAGE
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=OLD
Additional file assignments, as required
Name
Description
userdb
DDname of the user file
user.userdb
Data set name of the user file
Central version
To execute FIX PAGE under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
FORMAT
DD statements for the batch command facility (z/OS)
To format a new database file:
//
userdb
DD DSN=
user.userdb
,DISP=(NEW,
disp
),
// UNIT=
disk
,VOL=SER=
nnnnnn
,
// SPACE=(
space
)
To reformat an existing database file:
//
userdb
DD DSN=
user.userdb
,DISP=(OLD,PASS)
To format a new disk journal file:
//
j1jrnl
DD DSN=
idms.j1jrnl
,DISP=(NEW,
disp
), // UNIT=
disk
,VOL=SER=
nnnnnn
, // SPACE=(
space
)
To reformat an existing disk journal file:
//
j1jrnl
DD DSN=
idms.j1jrnl
,DISP=(OLD,PASS)
Additional database and journal file assignments, as required
To format a new SYSTRK file:
//
anydd
DD DSN=
user.systrkn
,DISP=(NEW,
disp
), // UNIT=
disk
,VOL=SER=
nnnnnn
, // SPACE=(
space
)
To reformat an existing SYSTRK file:
//
anydd
DD DSN=
user.systrkn
,DISP=(OLD,PASS)
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
disp
Disposition of the new file (CATLG, KEEP, or PASS)
disk
Symbolic device name of the file being formatted
nnnnnn
Volume serial number of the file being formatted
space
Space allocation for the file being formatted
j1jrnl
DDname of the disk journal file
idms.j1jrnl
Data set name of the disk journal file
anydd
Target DDname specified in the FORMAT SYSTRK statement
user.systrkn
Data set name of the SYSTRK file
Central version
To execute FORMAT AREA and FORMAT SEGMENT under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
INSTALL STAMPS
Local mode
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=OLD //userdict DD DSN=user.userdict,DISP=SHR //
sysjrnl
DD DSN=
idms.sysjrnl
,DISP=OLD
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
userdict
DDname of the database file containing the dictionary with the table definitions
sysjrnl
DDname of the tape journal file
idms.sysjrnl
Data set name of the tape journal file
Central version
To execute INSTALL STAMPS under the central version, modify the JCL shown previously as follows:
  • Remove the USERDICT and SYSJRNL DD statements.
  • Insert the following statement after the USERDB DD statement:
    //SYSCTL DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
LOAD
DD statements for the batch command facility (z/OS)
//
userdict
DD DSN=
user.userdict
,DISP=
disp
//userdb DD DSN=user.userdb,DISP=disp //SYS001 DD DSN=
user.input
,DISP=OLD //SYS002 DD DSN=
user.loadin
,DISP=(NEW,PASS),UNIT=
tapein
, // DCB=(RECFM=VB,LRECL=
rrrin
,BLKSIZE=
bbbin
) //SYS003 DD DSN=
user.loadout
,DISP=(NEW,PASS),UNIT=
tapeout
, // DCB=(RECFM=VB,LRECL=
rrrout
,BLKSIZE=
bbbout
) //SYSPCH DD DSN=&&
sortload
,DISP=(NEW,PASS), // UNIT=
disk
,SPACE=(TRK,1),DCB=BLKSIZE=80 //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
The SORTMSG and SORTWKnn files are only needed
when performing a complete LOAD.
Add additional SORTWKnn files as necessary
Name
Description
userdict
DDname of the database file containing the dictionary with the table definitions
user.userdict
Data set name of the database file containing the dictionary with the table definitions
userdb
DDname of the database file being loaded
user.userdb
Data set name of the database file being loaded
user.input
Data set name of the input file
user.loadin *
Data set name of the input SYS002 file; for sizing information see LOAD
tapein
Symbolic device name of the SYS002 file
rrrin
Record size of the SYS002 file
bbbin
Block size of the SYS002 file
user.loadout *
Data set name of the output SYS003 file; for sizing information see LOAD
tapeout
Symbolic device name of the SYS003 file
rrrout
Record size of the SYS003 file
bbbout
Block size of the SYS003 file
&&sortload
Data set name of the SYSPCH file
disk
Symbolic device name of the SYSPCH file
When running a complete LOAD, SYS002 and SYS003 must point to the
same
intermediate file. When running a stepped LOAD, SYS002 and SYS003 must point to a
different
intermediate file.
When running a complete LOAD, you must preallocate the file referenced by SYS002 and SYS003. Do not use a temporary data set for these files when running a complete LOAD.
LOCK
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
Central version
To execute LOCK AREA under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
MAINTAIN INDEX
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.olddb
,DISP=SHR
Additional existing database files assignments, as required
//SYS003 DD DSN=
user.dbl003
,DISP=(NEW,PASS),UNIT=
tape003
, // DCB=(RECFM=VB,LRECL=
rrr003
,BLKSIZE=
bbb003
) //SYS004 DD DSN=
user.dbl004
,DISP=(NEW,PASS),UNIT=
tape004
, // DCB=(RECFM=VB,LRECL=
rrr004
,BLKSIZE=
bbb004
) //SYS005 DD DSN=
user.dbl005
,DISP=(NEW,PASS),UNIT=
tape005
, // DCB=(RECFM=VB,LRECL=
rrr005
,BLKSIZE=
bbb005
) //SYS006 DD DSN=
user.dbl006
,DISP=(NEW,PASS),UNIT=
tape006
, // DCB=(RECFM=VB,LRECL=
rrr006
,BLKSIZE=
bbb006
) //SYSPCH DD DSN=
&&sort
,DISP=(NEW,PASS),UNIT=
disk
, // SPACE=(TRK,1),DCB=BLKSIZE=80 //RELDCTL DD DSN=
user.reldctl
,DISP=(NEW,CATLG),UNIT=
nnnn
, VOL=SER=
nnnnnn
, DCB=(RECFM=FB,LRECL=60,BLKSIZE=
bbbctl
) //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
Add additional SORTWKnn files as necessary
Name
Description
userdb
DDname of the existing database file
user.olddb
Data set name of the existing database file
user.dbl003
Data set name of the intermediate work file containing index descriptors from IDMSTABX
tape003
Symbolic device name of the SYS003 file
rrr003
Record size of the SYS003 file; see MAINTAIN INDEX for sizing information.
bbb003
Block size of the SYS003 intermediate work file
user.dbl004
Data set name of the intermediate work file containing the output from SORT3
tape004
Symbolic device name of the SYS004 file
rrr004
Record size of the SYS004 file; should be the same as rrr003
bbb004
Block size of the SYS004 intermediate work file; should be the same as bbb003
user.dbl005
Data set name of the intermediate work file containing pointers for user owned index sets from IDMSDBL3
tape005
Symbolic device name of the SYS005 file
rrr005
Record size of the SYS005 file; see MAINTAIN INDEX for sizing information
bbb005
Block size of the SYS005 intermediate work file
user.dbl006
Data set name of the intermediate work file containing sorted pointers for user owned index sets from SORT4
tape006
Symbolic device name of the SYS006 file
rrr006
Record size of the SYS006 file; should be the same as rrr005
bbb006
Block size of the SYS006 intermediate work file; should be the same as bbb005
&&sort
Data set name of the SYSPCH file containing sort parameters from IDMSTABX and IDMSDBL3
disk
Symbolic device name of the SYSPCH file
user.reldctl
Data set name of the reload control file containing control and set information
bbbctl
Blocksize of the RELDCTL file. It should be a multiple of 60 with a maximum size of 32,760.
MERGE ARCHIVE
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=idms.tjrnlold,DISP=(OLD,PASS),UNIT=tapein //SYS002 DD DSN=idms.tjrnlfix,DISP=(NEW,PASS),UNIT=tapeout, // DCB=BLKSIZE=bbbb //JRNM01 DD DSN=idms.tmrgold,DISP=(OLD,PASS),UNIT=tapein //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=bbbb //SORTWK01 DD UNIT=disk,SPACE=(TRK,(nnn,nnn)) Add additional SORTWKnn files as necessary
Name
Description
idms.tjrnlold
Data set name of the input tape journal file
tapein
Symbolic device name of the input tape journal file
idms.tjrnlfix
Data set name of the output tape journal
tapeout
Symbolic device name of the output tape journal file
bbbb
Block size of the output tape journal file, as defined in the DMCL
idms.tmrgold
Data set name of the input tape merged file. If none exists yet, specify //JRNM01 DD DUMMY
If the concatenated files have different block sizes, you must specify the following DCB parameter on the first file in the concatenation list:
DCB=(RECFM=VB,BLKSIZE=nnnn)
where nnnn is greater than or equal to (4 + the largest block size of any file in the concatenation list).
PRINT INDEX
DD statements for the batch command facility (z/OS)
//
sysjrnl
DD DUMMY //
userdb
DD DSN=
user.userdb
,DISP=SHR
Name
Description
sysjrnl
DDname of the dummy journal file
userdb
DDname of the database file
user.userdb
Data set name of the database file
PRINT JOURNAL
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=
idms.archjrnl
,DISP=SHR
Name
Description
idms.archjrnl
Data set name of the archive journal file
PRINT LOG
DD statements for the batch command facility (z/OS)
To print from the DDLDCLOG area:
//
dlogdb
DD DSN=
idms.dlogdb
,DISP=SHR
To print from the archive log file:
//SYS001 DD DSN=
idms.archive
,DISP=OLD //
dmsgdb
DD DSN=
idms.dmsgdb
, DISP=SHR //
sysjrnl
DD DSN=DUMMY
Name
Description
dlogdb
DDname of the data dictionary log area
idms.dlogdb
Data set name of the data dictionary log area
idms.archive
Data set name of the archive log file
dmsgdb
DDname of the data dictionary message area
idms.dmsgdb
Data set name of the data dictionary message area
sysjrnl
DDname of the tape journal file defined in the DMCL module
PRINT PAGE
DD statements for the batch command facility (z/OS)
//
userdb1
DD DSN=
user.userdb1
,DISP=SHR //
userdb2
DD DSN=
user.userdb2
,DISP=SHR
Additional database file assignments, as required
Name
Description
userdb1
DDname of the first database file
user.userdb1
Data set name of the first database file
userdb2
DDname of the second database file
user.userdb2
Data set name of the second database file
Central version
To execute PRINT PAGE under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
PRINT SPACE
DD statements for the batch command facility (z/OS)
//
userdb1
DD DSN=
user.userdb1
,DISP=SHR //
userdb2
DD DSN=
user.userdb2
,DISP=SHR
Additional database file assignments, as required
Name
Description
userdb1
DDname of the first database file
user.userdb1
Data set name of the first database file
userdb2
DDname of the second database file
user.userdb2
Data set name of the second database file
Central version
To execute PRINT SPACE FOR AREA or PRINT SPACE FOR SEGMENT under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
PRINT TRACE
The CA IDMS installation media contains the following sample JCL (intended for demonstration purposes only):
  • PTRCJCL - Contains a skeleton of the JCL required to run the PRINT TRACE utility.
PUNCH
Local mode
DD statements for the batch command facility (z/OS)
//
usercat
DD DSN=
user.ddlcat
,DISP=SHR //
usercatx
DD DSN=
user.ddlcatx
,DISP=SHR //
usercatl
DD DSN=
user.ddlcatl
,DISP=SHR //SYSPCH DD DSN=
&.&pch.
,DISP=(NEW,KEEP,DELETE), // DCB=(RECFM=FB,BLKSIZE=
nnnn
,LRECL=80) // SPACE=
space-specification
,UNIT=
unit
// VOL=SER
nnnnnn
//
sysjrnl
DD DSN=DUMMY
Name
Description
usercat
DDname of the database file containing the DDLCAT area of the dictionary
user.ddlcat
Data set name of the database file containing the DDLCAT area of the dictionary
usercatx
DDname of the database file containing the DDLCATX area of the dictionary
user.ddlcatx
Data set name of the database file containing the DDLCATX area of the dictionary
usercatl
DDname of the database file containing the DDLCATLOD area of the dictionary
user.ddlcatl
Data set name of the database file containing the DDLCATLOD area of the dictionary
Central version
To execute PUNCH under the central version, modify the JCL shown previously as follows:
  • Remove the USERCAT, USERCATX, USERCATL, and SYSJRNL DD statements.
  • Insert the following statement:
    //SYSCTL DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
idms.sysctl
Data set name of the SYSCTL file
RELOAD
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=
&&sortunld
,DISP=SHR //SYS002 DD DSN=
user.dbl002
,DISP=(OLD,DELETE) //SYS003 DD DSN=
user.dbl003
,DISP=(OLD,DELETE) //SYS004 DD DSN=
user.dbl004
,DISP=(NEW,PASS),UNIT=tape004, // DCB=(RECFM=VB,LRECL=
rrr004
,BLKSIZE=
bbb004
,) //SYS005 DD DSN=
user.dbl005
,DISP=(NEW,PASS),UNIT=tape005, // DCB=(RECFM=VB,LRECL=
rrr005
,BLKSIZE=
bbb005
) //SYS006 DD DSN=
user.dbl006
,DISP=(NEW,PASS),UNIT=tape006, // DCB=(RECFM=VB,LRECL=rrr006,BLKSIZE=bbb006) //SYS007 DD DSN=
user.dbl007
,DISP=(NEW,PASS),UNIT=tape007, // DCB=(RECFM=VB,LRECL=rrr007,BLKSIZE=bbb007) //SYS008 DD DSN=
user.dbl00
8,DISP=(NEW,PASS),UNIT=tape008, // DCB=(RECFM=VB,LRECL=rrr008,BLKSIZE=bbb008) //SYS009 DD DSN=
user.dbl009
,DISP=(NEW,PASS),UNIT=tape009, // DCB=(RECFM=VB,LRECL=rrr009,BLKSIZE=bbb009) //SYS010 DD DSN=
user.dbl010
,DISP=(NEW,PASS),UNIT=tape010, // DCB=(RECFM=VB,LRECL=
rrr010
,BLKSIZE=
bbb010
) //SYS011 DD DSN=
user.dbl011
,DISP=(NEW,PASS),UNIT=tape011, // DCB=(RECFM=VB,LRECL=rrr011,BLKSIZE=bbb011) //SYSPCH DD DSN=
&&sortreld
,DISP=(NEW,PASS),UNIT=disk, // SPACE=(TRK,1),DCB=BLKSIZE=80 //RELDCTL DD DSN=
user.reldctl
,DISP=SHR //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
Add additional SORTWKnn files as necessary
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Additional existing database files assignments, as required
Name
Description
&&sortunld
Data set name of the sort parameters created by UNLOAD
user.dbl002
Data set name of the file put out by UNLOAD as SYS002
user.dbl003
Data set name of the file put out by UNLOAD as SYS003
user.dbl004
Data set name of the intermediate work file containing the output from SORT1
tape004
Symbolic device name of the SYS004 file
rrr004
Record size of the SYS004 file; should be the same as the record size for SYS002 used by UNLOAD
bbb004
Block size of the SYS004 intermediate work file; should be the same as the block size for SYS002 used by UNLOAD
user.dbl005
Data set name of the intermediate work file containing member descriptors for chained sets from IDMSDBL2
tape005
Symbolic device name of the SYS005 file
rrr005
Record size of the SYS005 file; for sizing information, see RELOAD
bbb005
Block size of the SYS005 intermediate work file; must be at least 48 bytes (the size of a member descriptor plus four bytes)
user.dbl006
Data set name of the intermediate work file containing member descriptors for user owned index sets from IDMSDBL2
tape006
Symbolic device name of the SYS006 file
rrr006
Record size of the SYS006 file; for sizing information, see RELOAD
bbb006
Block size of the SYS006 intermediate work file; must be at least 48 bytes (the size of a member descriptor plus four bytes)
user.dbl007
Data set name of the intermediate work file containing the output of SORT2
tape007
Symbolic device name of the SYS007 file
rrr007
Record size of the SYS007 file; should be the same as the larger of:
the record size for SYS003 used by UNLOAD
the record size for SYS006
bbb007
Block size of the SYS007 intermediate work file; must be at least as large as the larger of:
the block size for SYS003 used by UNLOAD
the block size for SYS006
user.dbl00
8
Data set name of the intermediate work file containing the reformatted index information from IDMSDBLX
tape00
8
Symbolic device name of the SYS008 file
rrr00
8
Record size of the SYS008 file; should be the same as rrr007
bbb00
8
Block size of the SYS008 intermediate work file; should be the same as bbb007
user.dbl009
Data set name of the intermediate work file containing the sorted index set descriptors from SORT3
tape009
Symbolic device name of the SYS009 file
rrr009
Record size of the SYS009 file; should be the same as the larger of:
the record size for SYS005
the record size for SYS008
bbb009
Block size of the SYS009 intermediate work file; must be at least as large as the larger of:
the block size for SYS003 used by UNLOAD
the block size for SYS006
user.dbl010
Data set name of the intermediate work file containing prefix pointer information from IDMSDBL3
tape010
Symbolic device name of the SYS010 file
rrr010
Record size of the SYS010 file; for sizing information, see RELOAD
bbb010
Block size of the SYS010 intermediate work file; must be at least 44 bytes (the size of a pointer descriptor plus four bytes)
user.dbl011
Data set name of the intermediate work file containing sorted prefix pointer information from SORT4
tape011
Symbolic device name of the SYS011 file
rrr011
Record size of the SYS011 file; should be the same as rrr010
bbb011
Block size of the SYS011 intermediate work file; should be the same as bbb010
&&sortreld
Data set name of the SYSPCH file
disk
Symbolic device name of the SYSPCH file
user.reldctl
Data set name of the reload control file containing control and set information
bbbctl
Blocksize of the RELDCTL file. It must be a multiple of 60 with a maximum size of 32,760.
userdb
DDname of the database file
user.userdb
Data set name of the database file
REORG
DD statements for the batch command facility (z/OS)
When allocating the REORG control file or when running setup only
//RORGCTL DD DSN=
user.reldctl
,DISP=(NEW,CATLG), // UNIT=
disk
,VOL=SER=
nnnnnn
, // DCB=(RECFM=FB,LRECL=8192,BLKSIZE=
nnnn
)
DCB parameters are optional when creating the control file. When the parameters are not specified, REORG defaults to 8192 LRECL/BLKSIZE. If DCB parameters are specified, the minimum LRECL/BLKSIZE supported is 2048.
Manual creation of work files other than DBKEYS files
//wx
nnnnn
DD DSN=
user.workfile
,DISP=(NEW,CATLG), // UNIT=
disk
,VOL=SER=
nnnnnn
, // DCB=(RECFM=VB,BLKSIZE=
wrkbbb
)
Manual creation of DBKEYS work files
//WD
nnnnn
DD DSN=
user.workfile
,DISP=(NEW,CATLG), // UNIT=
disk
,VOL=SER=
nnnnnn
, // DCB=(RECFM=FB,LRECL=16,BLKSIZE=
dbkbbb
)
Manual references to work files
//wx
nnnnn
DD DSN=
user.workfile
,DISP=SHR
File assignments when running the unload phase
//RORGCTL DD DSN=
user.reldctl
,DISP=SHR //RORGJCL DD DSN=
user.jclfile
,DISP=SHR //unlddb DD DSN=
user.unldfile
,DISP=SHR
Additional database file assignments, as required if not using
dynamic allocation
Manual references to work files if not using dynamic
allocation
File assignments when running the reload phase
//RORGCTL DD DSN=
user.reldctl
,DISP=SHR //RORGJCL DD DSN=
user.jclfile
,DISP=SHR //relddb DD DSN-
user.reldfile
,DISP=SHR
Additional database file assignments, as required if not using
dynamic allocation
Manual references to work files if not using dynamic
allocation
//SORTMSG DD SYSOUT=A //SORTWK01 DD UNIT=
disk
,SPACE=(CYL,(
nnn
,
nnn
))
Additional SORTWKnn files as necessary
Name
Description
user.reldctl
Data set name of the REORG control file containing control information
user.jclfile
Data set name of the file containing JCL for automatic job submission
wxnnnnn
DDname for a work file. It must match the name generated in the Unload/Reload Work File Summary report.
user.workfile
Data set name of a work file when sectionly allocating work files
wrkbbb
Blocksize for a variable blocked sequential work file
WDnnnnn
DDname for a DBKEYS file. It must match the name generated in the Unload/Reload Work File Summary report.
dbkbbb
Blocksize for a fixed-blocked, sequential DBKEYS file. Must be a multiple of 16.
disk
Symbolic unit name for a device
nnnnnn
Volume serial number
unlddb
DDname of the existing database file
user.unldfile
Data set name of the existing database file
relddb
DDname of the target database file
user.reldfile
Data set name of the target database file
RESTORE
DD statements for the batch command facility (z/OS)
//
userdb1
DD DSN=
user.userdb1
,DISP=OLD //
userdb2
DD DSN=
user.userdb2
,DISP=OLD //SYS001 DD DSN=
user.bkp
,DISP=SHR
Additional database file assignments, as required
Name
Description
userdb1
DDname of the first database file
user.userdb1
Data set name of the first database file
userdb2
DDname of the second database file
user.userdb2
Data set name of the second database file
user.bkp
Data set name of the backup file
RESTRUCTURE
DD statements for the batch command facility (z/OS)
//
userdb1
DD DSN=
user.userdb1
,DISP=SHR //
userdb2
DD DSN=
user.userdb2
,DISP=SHR //SYS001 DD DSN=
idms.spill
,DISP=(NEW,PASS) // DCB=(RECFM=FB,BLKSIZE=
bbbb
)
Additional database file assignments, as required
Name
Description
userdb1
DDname of the first database file
user.userdb1
Data set name of the first database file
userdb2
DDname of the second database file
user.userdb2
Data set name of the second database file
idms.spill
Data set name of the spill file
bbbb
Block size of the spill file; it should be a multiple of 40 with a maximum size of 32,760.
RESTRUCTURE CONNECT
DD statements for the batch command facility (z/OS)
//userdb DD DSN=user.userdb,DISP=SHR //SYS001 DD DSN=idms.spill,DISP=OLD //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=bbbb //SORTWK01 DD UNIT=disk,SPACE=(TRK,(nnn,nnn))
Add additional SORTWKnn files as necessary
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
idms.spill
Data set name of the spill file.
bbbb
Block size of the spill file; it should be a multiple of 40 with a maximum size of 32,760
ROLLBACK
DD statements for the batch command facility (z/OS)
//SYS001 DD DSN=&&
archive
,DISP=OLD,UNIT=
tape
//
userdb
DD DSN=
user.userdb
,DISP=OLD
Additional database file assignments, as required
If using the SORT option add these statements:
//SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
Add additional SORTWKnn files as necessary
Name
Description
&&archive
Data set name of the complete archive or tape journal file
tape
Symbolic device name of the archive or tape journal file
userdb
DDname of the user database file
user.userdb
Data set name of the user database file
ROLLFORWARD
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=OLD
Add database file assignments, as required
If recovering from a standard journal file:
//SYS001 DD DSN=
&.&archive.
,DISP=(OLD),UNIT=
tape
If recovering from a journal extract file:
//
extract
DD DSN=
jrnl.extract
,DISP=OLD
If using the SORT option or processing a journal extract file, add these statements:
//SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn,nnn
))
Add SORTWKnn files as necessary
Name
Description
userdb
DDname of the user database file.
user.userdb
Data set name of the user database file.
&.&archive.
Data set name of the complete archive or tape journal file.
tape
Symbolic device name of the archive or tape journal file.
extract
DDname of the extract journal file. If not specified in the command it will default to SYS002.
jrnl.extract
Data set name of the extract journal file.
SYNCHRONIZE STAMPS
Local mode
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=OLD //userdict DD DSN=user.userdict,DISP=SHR //
sysjrnl
DD DSN=
idms.sysjrnl
,DISP=OLD
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
userdict
DDname of the database file containing the dictionary with the table definitions
sysjrnl
DDname of the tape journal file
idms.sysjrnl
Data set name of the tape journal file
Central version
To execute SYNCHRONIZE STAMPS under the central version, modify the JCL shown previously as follows:
  • Remove the USERDICT and SYSJRNL DD statements.
  • Insert the following statement after the USERDB DD statement:
    //SYSCTL DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
idms.sysctl
Data set name of the SYSCTL file
TUNE INDEX
DD statement for the batch command facility (z/OS)
//userdb DD DSN=
user.userdb
,DISP=SHR
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
Central version
To execute TUNE INDEX under the central version, modify the JCL shown previously as follows:
  • Optionally remove any journal and database DD statements.
  • Insert the following statement:
    //
    SYSCTL
    DD DSN=
    idms.sysctl
    ,DISP=SHR
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
UNLOCK
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=SHR
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
UNLOAD
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.olddb
,DISP=SHR
Additional existing database files assignments, as required
//
sysjrnl
DD DUMMY //SYS002 DD DSN=
user.dbl002
,DISP=(NEW,PASS),UNIT=
tape002
, // DCB=(RECFM=VB,BLKSIZE=
bbb002
) //SYS003 DD DSN=
user.dbl003
,DISP=(NEW,PASS),UNIT=
tape003
, // DCB=(RECFM=VB,BLKSIZE=
bbb003
) //SYSPCH DD DSN=
&&sortunld
,DISP=(NEW,PASS),UNIT=
disk
, // SPACE=(TRK,1),DCB=BLKSIZE=80 //RELDCTL DD DSN=
user.reldctl
,DISP=(NEW,CATLG),UNIT=
nnnn
, VOL=SER=
nnnnnn
, DCB=(RECFM=FB,LRECL=60,BLKSIZE=
bbbctl
)
Name
Description
userdb
DDname of the existing database file
user.olddb
Data set name of the existing database file
sysjrnl
DDname of the dummy journal file
user.dbl002
Data set name of the SYS002 output file
tape002
Symbolic device name of the SYS002 output file
bbb002
Block size of the SYS002 output file; must be at least the size of the largest database record plus 4 bytes
user.dbl003
Data set name of the SYS003 output file
tape003
Symbolic device name of the SYS003 output file
bbb003
Block size of the SYS003 output file
&&sortunld
Data set name of the sort parameters created by UNLOAD
disk
Symbolic device name of the sort parameter file
user.reldctl
Data set name of the reload control file containing control and set information
bbbctl
Size of the RELDCTL file. It should be a multiple of 60 with a maximum size of 32,760.
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
Name
Description
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
Name
Description
sysctl
DDname of the SYSCTL file
idms.sysctl
Data set name of the SYSCTL file
VALIDATE
DD statements for the batch command facility (z/OS)
//
userdb
DD DSN=
user.userdb
,DISP=
disp
//SYS002 DD DSN=
user.valin
,DISP=(NEW,PASS),UNIT=
tapein
, DCB=(RECFM=VB,LRECL=
rrrin
,BLKSIZE=
bbbin
) //SYS003 DD DSN=
user.valout
,DISP=(NEW,PASS), UNIT=
tapeout
, DCB=(RECFM=VB,LRECL=
rrrout
, BLKSIZE=
bbbout
) //SYSPCH DD DSN=
&.&sortval.
,DISP=(NEW,PASS) UNIT=
disk
,SPACE=(TRK,1),DCB=BLKSIZE=80 //SORTMSG DD SYSOUT=A,DCB=BLKSIZE=
bbbb
//SORTWK01 DD UNIT=
disk
,SPACE=(TRK,(
nnn
,
nnn
))
The SORTMSG and SORTWKnn files are only needed
when performing a complete VALIDATE.
Add additional SORTWKnn files as necessary
Name
Description
userdb
DDname of the database file
user.userdb
Data set name of the database file
user.valin *
Data set name of the input SYS002 file; for sizing information see VALIDATE
tapein
Symbolic device name of the SYS002 file
rrrin
Record size of the SYS002 file
bbbin
Block size of the SYS002 file
user.valout *
Data set name of the output SYS003 file; for sizing information see VALIDATE
tapeout
Symbolic device name of the SYS003 file
rrrout
Record size of the SYS003 file
bbbout
Block size of the SYS003 file
&.&sortval.
Data set name of the SYSPCH file
When running a complete VALIDATE, SYS002, and SYS003 must point to the
same
intermediate file. When running a stepped VALIDATE, SYS002 and SYS003 must point to a
different
intermediate file.