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.