Previous Topic: Example JCLNext Topic: EXTEND (Extend Data or Index Areas)


Sample Report: EXTBKUP

Information is reported about the AREA, TABLE, TABLEID, and number of records extracted. Zero records indicated that a null extract file was created because there were no records on the backup file. Each table specified in a FILEOUT statement (see FILEOUT (Define Output Data Sets)) must be found in the control records for the input backup file. If any of the specified tables are not found in the control records for the input backup file, a message in the report indicates the invalid table name, and the utility terminates as a failure.

Following is a sample EXTBKUP report.

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ FILEOUT DTFNAME=POLOUT,TABLE=POL,DEVICE=S005 FUNCTION=FILEOUT  DTFNAME=POLOUT TABLE=POL DEVICE=S005 Ž

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ EXTBKUP DEVICE=DISK,DTFNAME=INFILE FUNCTION=EXTBKUP  DEVICE=DISK DTFNAME=INFILE Ž

Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy ******************************************************************************** Page: 3 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Directory: PRODCXX BACKUP FILE INFORMATION JOBNAME RUN UNIT DATE TIME CXXNAME DBID SEQ RECID AREA DBUTLTY 42,395 mm/dd/ccyy hh.mm.ss PRODCXX 1 NAT NO OUTPUT TABLE INFORMATION AREA TABLE ID RECORDS POL POL 4 4 



Confirmation that records were extracted from the requested table, as specified by the FILEOUT statement.

The following is a sample z/VSE EXTBKUP report.

Date: mm/dd/ccyy ******************************************************************************** Page: 4 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ FILEOUT DTFNAME=OUT1,TABLE=PAY,DEVICE=DISK FUNCTION=FILEOUT  DEVICE=DISK DTFNAME=OUT1 TABLE=PAY Ž

Date: mm/dd/ccyy ******************************************************************************** Page: 5 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ FILEOUT DTFNAME=OUT2,TABLE=PMF,DEVICE=DISK FUNCTION=FILEOUT  DEVICE=DISK DTFNAME=OUT2 TABLE=PMF Ž

Date: mm/dd/ccyy ******************************************************************************** Page: 6 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ FILEOUT DTFNAME=OUT3,TABLE=POL,DEVICE=DISK FUNCTION=FILEOUT  DEVICE=DISK DTFNAME=OUT3 TABLE=POL Ž

Date: mm/dd/ccyy ******************************************************************************** Page: 7 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ EXTBKUP DTFNAME=PAYBKP,DEVICE=TAPE FUNCTION=EXTBKUP  DEVICE=TAPE DTFNAME=PAYBKP Ž

Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy ******************************************************************************** Page: 8 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Directory: PRODCXX BACKUP FILE INFORMATION JOBNAME RUN UNIT DATE TIME CXXNAME DBID SEQ RECID AREA DBUTLTY 42,395 mm/dd/ccyy hh.mm.ss PRODCXX 1 NAT NO OUTPUT TABLE INFORMATION AREA TABLE ID RECORDS PAY PAY 1 200  PMF PMF 2 200 DEM POL 4 4



Confirmation that records were extracted from the requested table.