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.