CSV data layout

 

The CSV file consists of a header and multiple rows, one row per interval, system and processor type. For readability reasons only the header line and the first data line, the start position of each column and its length are depicted:

 

Dataset: BVAU.TESTDATA.HIS.ZEC12A.RSLDATA                                

-----------------------------------------                                

Col  Header                         TYPE   Value first row      Pos | Len

---  ------                         ------ -------------------- ----+----

  1: Date-Time                      Text   12/06/14-00:00:00      1 |  17

  2: Date                           Date   12/06/14              19 |   8

  3: Time                           Time   00:00:00               6 |   8

  4: System                         Text   SYS1                  37 |   6

  5: CPUs                           Number 8                     44 |   4

  6: Type                           Text   CP                    49 |   4

  7: Speed                          Number 5504                  54 |   5

  8: Lpar Busy                      Number 6.16                  60 |   9

  9: IPCG                           Number 1777.86               70 |   7

 10: Problem State                  Number 0.00                  78 |  13

 11: Supervisor State               Number 100.00                92 |  16

 12: L1 Miss %                      Number 3.09                 109 |   9

 13: % sourced from L2              Number 75.39                119 |  17

 14: % sourced from L3              Number 18.74                137 |  17

 15: % sourced from local L4        Number 3.51                 155 |  23

 16: % sourced from remote L4       Number 0.25                 179 |  24

 17: % sourced from memory          Number 2.12                 204 |  21

 18: Relative Nest Intensity        Number 0.68                 226 |  23

 19: CPI                            Number 3.10                 250 |   5

 20: CPI: estimated Instruction Com Number 2.05                 256 |  37

 21: CPI: from finite Cache/Memory  Number 1.05                 294 |  29

 22: Estimated Cycles/L1 Miss       Number 33.90                324 |  24

 23: TLB1 Miss %                    Number 4.07                 349 |  11

 24: TLB1 Miss Cycles               Number 33.84                361 |  16

 25: PTE% of all TLB1 Misses        Number 26.78                378 |  23

 26: Miss Penalty                   Number 59.75                402 |  12

 27: RVN1                           Number 1                    415 |   4

 28: RVN2                           Number 3                    420 |   4

 29: Mach                           Number 2827                 425 |   4

 30: Model                          Text   HA1                  430 |   5

 31: Sets                           Number 0                    436 |   4

 32: Counts                         Number 62                   441 |   6

 33: CBAS                           Number 6                    448 |   4

 34: CPRB                           Number 0                    453 |   4

 35: CCRY                           Number 0                    458 |   4

 36: CEXT                           Number 56                   463 |   4