Extract JCL
The extract JCL shown in the following figure performs the batch portion of the extract process and generates the appropriate reports. The extract JCL can be coded and executed separately in a batch job. In addition, File-AID/RDX can automatically generate the JCL through the online extract screens.
Extract JCL
// PARM=(FR,2,B)
//STEPLIB DD DSN=Combined-File-AID/RDX-load-libraries,DISP=SHR
// DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB DD DSN=File-AID-message-library,DISP=SHR
//RDXEC DD DSN=extract-criteria-file(member),DISP=SHR
//EXTRACT DD DSN=extract-to-file-name,DISP=SHR
//EXTPARMS DD DSN=extract-parms-file,DISP=SHR
//*
//DDxxx DD DSN=file-name-of-MVS-object-xxx,DISP=(SHR)
//LAYxxx DD DSN=layout-file-name-for-MVS-object-xxx,DISP=(SHR)
//XREFxxx DD DSN=XREF-file-name-for-MVS-object-xxx,DISP=(SHR)
//KEYxxxxx DD DSN=output key file-name,DISP=OLD
//SORTWK01 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//SORTWK02 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//SORTWK03 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//DFSPARM DD UNIT=SYSDA,
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=8000,DSORG=PS),
// SPACE=(TRK,(1,1),RLSE),
// DISP=(NEW,DELETE,DELETE)
//*
//X37MSG DD SYSOUT=(*)
//PROGRESS DD SYSOUT=(*)
//REPORT DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSTERM DD SYSOUT=(*)
//IXRPT DD SYSOUT=(*)
//SYSPRINT DD SYSOUT=(*)
//TPTPRINT DD SYSOUT=(*)
//CHKPTCTL DD DSN=checkpoint control file,
/
/ DISP=SHR
//CHKPT DD DSN=checkpoint data file,
// DISP=SHR
//VISUALIZ DD DSN=file-name-of-Topaz Extract Visualizer file,
// DISP=(NEW,CATLG,CATLG),
// DCB=(RECFM=VBA,LRECL=27962,BLKSIZE=27966),
// SPACE=(CYL,(10,2,10)),
// UNIT=SYSDA
//SYSOUT DD SYSOUT=(*)
//SORTLST DD SYSOUT=(*)
//IDCAMLST DD SYSOUT=(*)
//SYSUDUMP DD SYSOUT=(*)
//DPARMS DD *
CYL
1
1
//*
//CLEANEXT EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048 XFRJCLXT
//SYSPRINT DD SYSOUT=*
//SYSIN DD * IDCAMS DELETE STATEMENTS FOLLOW
DELETE extract-parms-file,
SET MAXCC=0
SET LASTCC=0
//*
//* /*XFRJCLXT*/
XFREXEC is the File-AID/RDX program name.
The parameter information in the PARM field in the EXEC statement must have the format as shown in the following table:
EXEC Statement PARM Field—Extract Step
Parameter | Default | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 2 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
Extract from Db2 Image Copy
For an extract from Db2 Image Copy the program name is XFRIMAGE and requires that the File-AID/RDX load library be authorized.
Extract JCL XFRIMAGE Parm statement
// PARM=(FR,2,B)
The parameter information in the PARM field in the EXEC statement must have the following format:
EXEC Statement PARM Field—Extract Step for Image Copy
Parameter | Default | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 2 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
DD statements
The following DD statements are required for extract:
DD Statements—Extract
DD statement | Description |
|---|---|
STEPLIB | File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD) and Db2 load libraries |
RDXMLIB | Library containing File-AID/RDX messages. |
RDXEC | Library containing the File-AID/RDX extract criteria (only required if extract criteria is being applied). |
EXTRACT | File to which extracted data is written. |
DELIMEXT | File to which extracted data is written when Delimited extract option was specified (see Delimited Format Options). DELIMEXT DD is used instead of EXTRACT DD. |
EXTPARMS | File containing the extract parameters (see EXTPARMS File). |
DDxxx | File name of the MVS object xxx; only applicable when extracting MVS objects. |
LAYxxx | File name of layout file for the MVS object xxx; when extracting MVS objects. |
KEYxxxxx | File name of the defined Output Key file; when extracting KEY relationships. |
XREFxxx | File name of XREF file for the MVS object xxx; when extracting MVS objects. |
SYSOUT | Output class for SORT utility. |
RDXSQLCD | Output class for detailed SQL error information from Db2. |
SYSTERM | Output class for runtime errors. |
SYSPRINT | Standard output stream. |
SYSIN | Control card used by File-AID/RDX to sort data during the extract process. |
SORTWK01 | Work files required by the SORT utility. |
X37MSG | Output class for error messages and reports. |
TPTPRINT | Standard output stream for extract diagnostics. |
CHKPTCTL | Optional Checkpoint Control File. |
CHKPT | Optional Checkpoint Data File. |
VISUALIZ | File name of the optional Topaz Extract Visualizer file. |
IDCAMLST | Parameters for temporary extract files for XML and MVS objects. |
DPARMS | Space allocation parameters for temporary extract files. Note: File-AID/RDX will dynamically reallocate temporary work files, key tree and chase key files only when running extracts using 64 bit memory (above the bar) processing support. |
EXTPARMS File
The EXTPARMS file contains the relevant parameters to execute File-AID/RDX programs. Each program function, Extract, Load, Disguise, etc. generates different parameters that are necessary for that function to run correctly. Do NOT change any of the parameters in the EXTPARMS file, unless instructed to do so by BMC customer support for diagnostic purposes. The TEST mode indicator (N or Y) is used for debugging purposes.
Return Codes
An execution return code (RC) appears in the output listing. For return codes other than 0, an error code and message indicating the specific problem also appear in the listing. In general, the return codes can be summarized as follows:
Return Code | Description |
|---|---|
0 | Job ran to completion. |
4 | Job ran to completion, warnings issued. |
8 | Job completed with error. |
16 | Severe error, job aborted. |