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:

Table 1. Commands 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:

Figure 1. Sample Columnar report with page headings (HPCACOLP)
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:

Figure 2. Sample Columnar report with no page headings (HPCACOLS)
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
The value is the relative number of the data set group corresponding to the ddname. If the number is 0, the data set is the index of a VSAM KSDS. Records with relative number 0 are used only for the Track Recovery option of database recovery.
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.