Maintain HDB container data sets

Scroll Right (F11) to view the list of container data sets.
Figure 1. Maintain HDB data sets
  File  Systems  Options  Help                                                 
------------------------------------------------------------------------------ 
                                 Maintain HDB               Row 1 of 1 More: > 
Command ===> ________________________________________________ Scroll ===> CSR_ 
                                                                               
Maintain HDB data sets.                                                        
                                                                               
Name . . . . . : CICSP1   Type SUMMARY  APPLID  CICSP1__ +  Image  ________    
Qualifier  . . . QQQQ       /  Explorer                                        
Description  . . Summary HDB for CICSP1__________                          
                                                                                
Specify View . . 2  1. Options  2. Data Sets  3. Volumes
                                                                     Status
/  Data Set Name                                       Start         HDB DB2 
S  CPA510.XCTL.V680LIST.D12212.T162249.HDB      2012/07/21 09:48:54  Del Exp   
********************************* End of list *********************************
 
 F1=Help    F3=Exit    F4=Prompt    F7=Backward    F8=Forward    F10=Actions
F11=Right  F12=Cancel                                                     
The HDB container data set details shown here are:
  • The name of the data set. The suffix indicates the contents:
    • .HDB indicates that the data set contains CICS® statistics or transaction performance data.
    • .HPA indicates that the data set contains performance alert data.

    Because HDB and HPA containers have the same space allocation but different record length and record counts, they are likely to fill at different rates. Therefore they will be allocated at different times resulting in different name identifiers. In other words, there will not usually be a one-to-one relationship between associated HDB and HPA data sets.

  • The time stamp of the first record in the data set.
  • The status of the HDB container data set:
    • If delete pending, it is marked Del.
    • If the HDB retention period has been exceeded, it is marked Exp (expired).
    • If neither delete pending nor expired, it is marked Act (active).
  • The status of DB2® table data associated with the HDB container data set:
    • If the DB2 retention period has been exceeded, it is marked Exp (expired).
    • If not all data has expired, it is marked Pxp (partially expired).
    • If neither delete pending nor expired, it is marked Act (active).
    • If the status is unavailable (because the DB2 retention period is not specified), it is marked n/a.
Data sets and DB2 data marked Del or Exp are physically deleted when Housekeeping is next run.

Associated HDB and HPA containers can be managed independently. This means that they do not have to be deleted at the same time.

Scroll Right (F11) to view the VOLSER where the data set resides, if active.

Line Actions

⁄
Display the selection list of line actions.
S
Select the HDB data set to view status information, as shown in Figure 2.
B
Browse the data set using ISPF Browse, as shown in Figure 3
D
Delete the HDB data set. The data set is deleted in the HDB now, and physically deleted when HDB Housekeeping is next run.
U
Undo. Reverse an earlier Delete action and reinstate the data set as active in this HDB. Undo is only available on a Deleted data set until Housekeeping is run.
C
Convert the HDB data set. Convert Domain Subpools HDB records from the format of CICS PA V5.2 and earlier versions to the correct format. See Convert HDB data set for more information.

View HDB data set statistics

The HDB Data Set panel displays details about the HDB container data set:
  • The name of the data set and VOLSER where it resides.
  • The status of the data set: either Active, Expired, or Deleted.
  • The date the Load HDB was run and the data set was created.
  • The expiry date of the HDB data set determined by the HDB retention period. The expiry date is blank if the data set is deleted.
  • The time period spanned by the records in the data set.
  • The number of records in the data set.
  • The status of the DB2 data: either Active, Expired, Pxpired (partially expired), or n/a.
  • The expiry date of the DB2 data determined by the DB2 retention period.
Figure 2. View HDB data set statistics
                            HDB Data Set          
Command ===> _______________________________________________
                                                  
Data Set Name  . . : CPA510.XCTL.V680LIST.D12212.T162249.HDB
VOLSER . . . . . . : USER01                       
                                                  
HDB Status . . . . : Deleted            
Creation Date  . . : 2012/07/30 16:22:55
Expiry Date  . . . :                    
                                        
Data Start . . . . : 2012/07/21 09:48:54
Data End . . . . . : 2012/07/22 17:05:24
Record Count . . . : 503                
                                         
DB2 Status . . . . : Expired            
DB2 Expiry Date  . : 2012/07/23 17:05:24
                                                  
 F1=Help    F3=Exit    F6=Resize F12=Cancel       

Browse HDB data set contents

The B line action displays the contents of a container data set using ISPF Browse.
Figure 3. Browse contents of HDB container data set
 ISRBROBA  CPPX.#STAT01.D13199.T231503.HDB            Line 00000000 Col 001 080 
  Command ===>                                                  Scroll ===> PAGE 
********************************* Top of Data **********************************
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..>LGJ
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..AITM
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..AP_T
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..AP_T
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..AP_T
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APAI
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APBM
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APCO
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APDW
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APEC
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APIC
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..APUR
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..ASYN
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BAGE
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BAOF
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BAOF
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BR_B
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BR_B
2013-07-17-00.00.00CXVT22M FSY1    CXVT22M 620EOD        ....07:33:10005A2..BR_B

Convert HDB data set

Convert an HDB data set if you are migrating from CICS PA V5.2, or an earlier version, and you have already loaded CICS Statistics Domain Subpool records into the HDB. If you are not sure which data set in the HDB to convert, enter C next to all the data sets.

In CICS PA V5.2 and earlier versions, the Initial Free Area field was incorrectly defined as 8 bytes in length instead of 4 bytes. This error was corrected in CICS PA V5.3 but Domain Subpool records loaded into the HDB using a previous version of CICS PA are not reported correctly because of the change in the record definition. The Convert command reformats previously-loaded Domain Subpools HDB records to the correct format.

Note: HDBs loaded using CICS PA V5.3 or later versions are already in the correct format. There is no need to run the Convert command on these HDBs, but there is no negative effect if you do so.

The Convert command performs the following steps:

  1. Deletes the temporary data set if it exists.
  2. Copies and, if required, reformats records from the container data set to the temporary data set.
  3. If any records were reformatted, deletes container data set, and renames the temporary data set to the container data set name.
  4. If no records were reformatted, deletes the temporary data set.
Figure 4. Convert HDB data set JCL
 000001 //ABC JOB (ACCOUNT),'NAME'
 000002 //* CICSPA V5R3 Delete HDB Temporary Container Data Set
 000003 //HKEEP1   EXEC PGM=IDCAMS
 000004 //SYSPRINT DD  SYSOUT=*
 000005 //SYSIN    DD  *
 000006  DELETE CPA530.USER.HDB1.D15134.T120752.TMP
 000007  SET MAXCC=0
 000008 /*
 000009 //* CICSPA V5R3 Convert HDB Container Data Set
 000010 //CICSPA1  EXEC PGM=CPAHDREP
 000011 //STEPLIB  DD  DSN=CICSPA.V5R3M0.SCPALINK,
 000012 //             DISP=SHR
 000013 //SYSPRINT DD  SYSOUT=*
 000014 //HDBIN    DD  DSN=CPA530.USER.HDB1.D15134.T120752.HDB,
 000015 //             DISP=SHR
 000016 //HDBOUT   DD  DSN=CPA530.USER.HDB1.D15134.T120752.TMP,
 000017 //             SPACE=(CYL,(10,10),RLSE),
 000018 //             DISP=(NEW,CATLG)
 000019 /*
 000020 //* CICSPA V5R3 Rename HDB Container Data Set
 000021 //HDREN1   EXEC PGM=IDCAMS,COND=(4,EQ,CICSPA1)
 000022 //SYSPRINT DD  SYSOUT=*
 000023 //SYSIN    DD  *
 000024  DELETE CPA530.USER.HDB1.D15134.T120752.HDB
 000025  ALTER  CPA530.USER.HDB1.D15134.T120752.TMP -
 000026         NEWNAME(CPA530.USER.HDB1.D15134.T120752.HDB)
 000027 /*
 000028 //* CICSPA V5R3 Delete Temporary Data Set if no changes
 000029 //TMPDEL1  EXEC PGM=IDCAMS,COND=(0,EQ,CICSPA1)
 000030 //SYSPRINT DD  SYSOUT=*
 000031 //SYSIN    DD  *
 000032  DELETE CPA530.USER.HDB1.D15134.T120752.TMP
 000033 /*