HDB Extract record format

The format of the HDB Extract record is determined by the particular HDB and the run time options. Here are some examples. Each field in the record is separated by a text file field delimiter, which by default is a semicolon (;). Optionally, the first record contains the field labels.
Figure 1. List HDB Extract file
Start Time;MVS;APPLID;Tran;Userid;Program;TaskNo;Response Time;Dispatch Time;User CPU Time;Suspend Time;DispWait Time; . . .
07:41:29.998;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      17;   .1413;   .0708;   .0082;   .0705;   .0680;   .0000;      
07:41:29.995;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      14;   .2025;   .0195;   .0022;   .1830;   .1808;   .0000;      
07:41:29.995;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      11;   .3219;   .0658;   .0096;   .2562;   .2487;   .0000;      
07:41:29.995;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      12;   .4355;   .0976;   .0116;   .3379;   .2886;   .0000;      
07:41:29.999;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      19;   .4625;   .0669;   .0056;   .3956;   .3856;   .0000;      
07:41:29.999;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      18;   .5860;   .0998;   .0071;   .4862;   .4820;   .0000;      
07:41:29.997;MV2C;IYK3Z4  ;CSSY;CICSUSER;DFHAPATT;      16;   .7682;   .1838;   .0131;   .5844;   .5694;   .0000;      
07:41:29.995;MV2C;IYK3Z4  ;CGRP;CICSUSER;DFHZCGRP;      13;   .8097;   .0244;   .0026;   .7852;   .7827;   .0000;      
Figure 2. Summary HDB Extract file
Start Date;Start Time;MVS;APPLID;Tran;#Tasks;Response Time Avg;Dispatch Time Avg;User CPU Time Avg;Suspend Time . . .
2010/12/15 15:00:00;MV2C    ;IYK3ZAC1;CSHQ    ;       1;55155.62;   .2103;   .0212;55155.41;   .0331;   .0001; 
2010/12/15 15:00:00;MV2C    ;IYK3ZAC1;CSNC    ;       1;55159.06;   .3379;   .0041;55158.72;   .0356;   .0001; 
2010/12/15 15:00:00;MV2C    ;IYK3ZAC1;CSNE    ;       1;55153.97;   .0881;   .0060;55153.88;   .0042;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV1;CEX2    ;       1;50237.83;   .5030;   .2717;50237.33;   .1800;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV1;CSHQ    ;       1;50234.95;   .3105;   .0190;50234.64;   .5761;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV1;CSNC    ;       1;50393.54;   .4259;   .0058;50393.12;   .0026;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV1;CSNE    ;       1;50389.87;   .1321;   .0177;50389.74;   .0074;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV2;CEX2    ;       1;50241.24;   .2630;   .1828;50240.98;   .2255;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV2;CKAM    ;       1;50239.91;   .0875;   .0044;50239.82;   .0522;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV2;CSHQ    ;       1;50238.49;   .3122;   .0197;50238.18;   .8023;   .0001; 
2010/12/15 18:00:00;MV2C    ;IYK2ZFV2;CSNC    ;       1;50248.39;   .4899;   .0051;50247.90;   .0064;   .0001; 
Figure 3. Statistics HDB Extract file
CPA.STAT01.STAT060A                                                                              
                                                                                                 
Start Time;APPLID;MVSID;Global_Statistics_Length;CICS_TCB_MODEs;CICS_TCB_POOLs;Current_ICV_Time;C . . .
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;128;18;4;5000;5000;500;32768;0;1;34;54;2010-02-15-16.20.19;
2010-02-16-07.42.00;IYK3Z4  ;MV2C    ;128;18;4;5000;5000;500;32768;0;1;16;44;2010-02-16-07.41.38;
2010-02-16-07.44.00;IYK3Z4  ;MV2C    ;128;18;4;5000;5000;500;32768;0;1;16;17;2010-02-16-07.41.38;
2010-02-16-07.44.24;IYK3Z4A1;MV2C    ;128;18;4;5000;5000;500;32768;0;1;14;44;2010-02-16-07.41.33;
                                                                                                 
                                                                                                 
CPA.STAT01.STAT060B                                                                              
                                                                                                 
Start Time;APPLID;MVSID;TCB_Mode_Name;TCB_Mode_Open;TCB_Pool;TCB_Attaches;TCB_Attach_Failu . . .       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;QR;NOTOPEN ;NA      ;0;0;1;1;1;1;0;0;0;0;0;0;0;5787;       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;RO;NOTOPEN ;NA      ;0;0;1;1;1;1;0;0;0;0;0;0;0;24;15       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;CO;UNKNOWN ;NA      ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;00.       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;SZ;UNKNOWN ;NA      ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;00.       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;D2;UNKNOWN ;NA      ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;00.       
2010-02-16-07.39.30;IYK3ZAC1;MV2C    ;JM;NOTOPEN ;NA      ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;00.       

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//report-reference/cparr203.htm