Columnar reports (HPCACOLP and HPCACOLS)
You can direct the Columnar report with page headings to HPCPRINT DD or HPCACOLP DD, or both.
The Columnar report (no page headings) is selected by the HPCACOLS DD.
The following table shows the commands available for generating columnar reports:
Command | Function |
---|---|
RPT.COLUMNS=YES/NO | Direct the report output to HPCPRINT |
RPT.ORDER=DBD/GROUP/CC | Specifies the sort sequence |
RPT.DATE=MDY/DMY/YMD/YDM | Specifies the date format for report headers |
HPCACOLP DD | Directs output to HPCACOLP |
HPCACOLS DD | Directs output to HPCACOLS |
Report order determines both the sequence of lines within the report and the sequence of fields within the line. Report order options include the following:
- DBD = DBD,DDN,NUM,GROUP,DATE,TIME ...
- GROUP = GROUP, DATE, TIME,DBD,DDN,NUM ...
- CC = CC,GROUP,DATE,TIME,DBD,DDN,NUM ...
The default order is DBD.
The following example shows a Columnar report with page headings:
5655-V86 HPCACOLP HPCA REPORT FILE
5655-V86 IMS Recovery Solution Pack for z/OS Version 2 Release 1 PAGE 1
2024/03/14 02.04.04 HPCA1 (JOB03120) HPCMAIN
HPCA RUN 03/14/2024 02:01:45
DBDNAME DDNAME NUM CA GROUP DATE TIME DFSULOG DFSUCUMO DFSUCUMN PURGE CC DBRC
-------- -------- --- -------- ------ ---------- --------- --------- --------- ---------------------- ---- ----
PRSB02Z PRSB02VA 47 PRSB02Z 24.074 02:01:47.1 000000230 000000000 000000021 24064022329773762+0000 0000 NO
PRSB02Z PRSB02VB 48 PRSB02Z 24.074 02:01:47.1 000000237 000000000 000000027 24064022329860327+0000 0000 NO
PRSB02Z PRSB02V0 37 PRSB02Z 24.074 02:01:47.1 000000254 000000000 000000029 24064022356428184+0000 0000 NO
The following example shows a Columnar report with no page headings:
HPCA RUN 03/14/2024 02:01:45
DBDNAME DDNAME NUM CA GROUP DATE TIME DFSULOG DFSUCUMO DFSUCUMN PURGE CC DBRC
-------- -------- --- -------- ------ ---------- --------- --------- --------- ---------------------- ---- ----
PRSB02Z PRSB02VA 47 PRSB02Z 24.074 02:01:47.1 000000230 000000000 000000021 24064022329773762+0000 0000 NO
PRSB02Z PRSB02VB 48 PRSB02Z 24.074 02:01:47.1 000000237 000000000 000000027 24064022329860327+0000 0000 NO
PRSB02Z PRSB02V0 37 PRSB02Z 24.074 02:01:47.1 000000254 000000000 000000029 24064022356428184+0000 0000 NO
Field description of the Columnar report:
- DBDNAME
- DBD name in the CA group. Part name if the database is a HALDB.
- DDNAME
- DD or area name in the CA group.
- NUM
- Indicates the data set number
- 1
- Indicates the prime data set
- 2
- Indicates the overflow data set
- 0
- Indicates the VSAM sequence set for KSDS
- CA GROUP
- CA group name
- DATE
- TIME
- Start time of CA creation in each CA group.
- DFSULOG
- DFSUCUMO
- DFSUCUMN
- Indicates the number of logical records processed for the DBDS or area.
- PURGE
- Indicates the date and time specified on the SYSIN control statement.
- CC
- Indicates the return code issued by the change accumulation processing.
- DBRC
- Indicates whether the RECON data sets were successfully updated to reflect the results.