Data set statistics record layout

The following table shows the record layout for data set statistics.

Offset (Dec)

Format

Length

Description

SAS format

SMF header

1

Binary

1

System indicator

PIB1.

2

Binary

1

Record number

PIB1.

3


8

SMF timestamp

SMFSTAMP8.

11

Char

4

SID

$4.

XBM header

15

Binary

1

Record Type

PIB1.

16

Char

4

XBM SSID

$4.

20

Char

8

Version text

$8.

28

Binary

1

Number of sections

PIB1.

Data set statistics section

00

Binary

4

Length of Section

PIB4.

04

Binary

4

Object ID (Data Sets = 113)

PIB4.

08

NA

4

Reserved

NA

12

NA

4

Reserved

NA

16

NA

2

Reserved

NA

18

NA

2

Reserved

NA

20

NA

8

Create timestamp

NA

28

NA

8

Statistics timestamp

NA

36

NA

8

Interval time in seconds

RB8.

44

NA

NA

Reserved

NA

48

Binary

1

Compress switch

PIB1.

49

Binary

1

Active switch

PIB1.

50

Binary

1

Cache type

PIB1.

51

Char

45

Data set name

$44

96

Binary

4

Priority

PIB4.

100

Char

33

Activating management set

$32.

133

NA

7

Reserved

NA

140

Binary

8

Cache used bytes

PIB8.

148

Binary

8

Cache original bytes

PIB8.

156

Binary

8

Cache compressed bytes

PIB8.

164

Binary

8

Blocks written to DASD

PIB8.

172

Binary

8

Snapshot of WRITES

PIB8.

180

Binary

8

Snapshot of WRITES1

PIB8.

188

Binary

8

Blocks written to cache

PIB8.

196

Binary

8

Snapshot of CWRITES

PIB8.

204

Binary

8

Snapshot of CWRITES1

PIB8.

212

Binary

8

Cache write failures

PIB8.

220

Binary

8

Block read while inactive (from DASD)

PIB8.

228

Binary

8

Snapshot of READS

PIB8.

236

Binary

8

Snapshot of READS1

PIB8.

244

Binary

8

Blocks read while active (from cache and DASD)

PIB8.

252

Binary

8

Snapshot of AREADS

PIB8.

260

Binary

8

Snapshot of AREADS1

PIB8.

268

Binary

8

Blocks satisfied from cache

PIB8.

276

Binary

8

Snapshot of HITS

PIB8.

284

Binary

8

Snapshot of HITS1

PIB8.

292

Binary

8

Cache read failures

PIB8.

300

Binary

8

Bytes output to disk

PIB8.

308

Binary

8

Output time in microseconds

PIB8.

316

Binary

8

Bytes written to cache

PIB8.

324

Binary

8

Write time in microseconds

PIB8.

332

Binary

8

Bytes read from cache

PIB8.

340

Binary

8

Read time in microseconds

PIB8.

348

Binary

8

Bytes input from DASD

PIB8.

356

Binary

8

Input time in microseconds

PIB8.

364

Binary

8

Cache high water mark

PIB8.

372

Binary

8

Accumulated cache writes before resetting statistics (0 if statistics are not reset)

PIB8.

380

Binary

8

Accumulated bytes written to cache before resetting statistics

PIB8.

388

Char

1

Dynamic cache flag ‘y’

$1.

389

Char

1

Statistics reset ‘y’

$1.

390

Char

1

Dynamic deactivate ‘y’

$1.

391

Char

1

Inefficient blocksize ‘y’

$1.

392

Binary

4

Listable flag

PIB4.

396

Binary

4

Self address

PIB4.

400

Char

1

Global IO enabled ‘y’

$1.

401


3

Reserved


404

Binary

8

Cache byte limit

PIB8.

Snapshot data set statistics section

00

Binary

4

Length of Section

PIB4.

04

Binary

4

Object ID (Data Sets = 113)

PIB4.

08

NA

4

Reserved

NA

12

NA

4

Reserved

NA

16

NA

2

Reserved

NA

18

NA

2

Reserved

NA

20

NA

8

Create timestamp

NA

28

NA

8

Statistics timestamp

NA

36

NA

8

Interval time in seconds

RB8.0

44

Binary

4

Cache byte limit

PIB4.

48

Binary

1

Compress switch

PIB1.

49

Binary

1

Active switch

PIB1.

50

Binary

1

Cache type

PIB1.

51

Char

45

Data set name

$44

96

Binary

4

Priority

PIB4.

100

Char

33

Activating management set

$32.

133

NA

7

Reserved

NA

140

Binary

8

Cache used bytes

PIB8.

148

Binary

8

Cache original bytes

PIB8.

156

Binary

8

Cache compressed bytes

PIB8.

164

Binary

8

Blocks written to DASD

PIB8.

172

Binary

8

Snapshot of WRITES

PIB8.

180

Binary

8

Snapshot of WRITES1

PIB8.

188

Binary

8

Blocks written to cache

PIB8.

196

Binary

8

Snapshot of CWRITES

PIB8.

204

Binary

8

Snapshot of CWRITES1

PIB8.

212

Binary

8

Cache write failures

PIB8.

220

Binary

8

Block read while inactive

PIB8.

228

Binary

8

Snapshot of READS

PIB8.

236

Binary

8

Snapshot of READS1

PIB8.

244

Binary

8

Blocks read while active

PIB8.

252

Binary

8

Snapshot of AREADS

PIB8.

260

Binary

8

Snapshot of AREADS1

PIB8.

268

Binary

8

Blocks satisfied from cache

PIB8.

276

Binary

8

Snapshot of HITS

PIB8.

284

Binary

8

Snapshot of HITS1

PIB8.

292

Binary

8

Cache read failures

PIB8.

300

Binary

8

Bytes output to disk

PIB8.

308

Binary

8

Output time in microseconds

PIB8.

316

Binary

8

Bytes written to cache

PIB8.

324

Binary

8

Write time in microseconds

PIB8.

332

Binary

8

Bytes read from cache

PIB8.

340

Binary

8

Read time in microseconds

PIB8.

348

Binary

8

Bytes input from DASD

PIB8.

356

Binary

8

Input time in microseconds

PIB8.

364

Binary

8

Cache high water mark

PIB8.

372

Binary

8

Accumulated cache writes before resetting statistics (0 if statistics are not reset)

PIB8.

380

Binary

8

Accumulated bytes written to cache before resetting statistics

PIB8.

388

Char

1

Dynamic cache flag ‘y’

$1.

389

Char

1

Statistics reset ‘y’

$1.

390

Char

1

Dynamic deactivate ‘y’

$1.

391

Char

1

Inefficient blocksize ‘y’

$1.

392

Binary

8

Cacheable flag

PIB8.

400

Char

1

Global IO enabled ‘y’

$1.

401

Char

31

Reserved


Db2 statistics section

00

Binary

4

Length of Section

PIB4.

04

Binary

4

Object ID (Db2 DSN = 154)

PIB4.

08

Binary

4

Reserved

NA

12

Binary

4

Reserved

NA

16

Binary

2

Db2 DBID

PIB2.

18

Binary

2

Db2 PSID

PIB2.

20

Char

8

Database name

$8.

28

Char

8

Table space name

$8.

36

Char

4

Partition

$4.

40

Char

5

Db2 SSID

$4.

45

Char

1

Compression type key

$1.

46

NA

6

Reserved

PIB8.

52

Binary

8

Sync reads SIOs

PIB8.

60

Binary

8

Snapshot of SREADS

PIB8.

68

Binary

8

Snapshot of SREADS1

PIB8.

76

Binary

8

Sync writes SIOs

PIB8.

84

Binary

8

Snapshot of SWRITES

PIB8.

92

Binary

8

Snapshot of SWRITES1

PIB8.

100

Binary

8

Sync reads total time

PIB8.

108

Binary

8

Snapshot of SRTIME

PIB8.

116

Binary

8

Snapshot of SRTIME1

PIB8.

124

Binary

8

Sync writes total time

PIB8.

132

Binary

8

Snapshot of SWTIME

PIB8.

140

Binary

8

Snapshot of SWTIME1

PIB8.

148

Binary

8

Async reads SIOs

PIB8.

156

Binary

8

Snapshot of AREADS

PIB8.

164

Binary

8

Snapshot of AREADS1

PIB8.

172

Binary

8

Async writes SIOs

PIB8.

180

Binary

8

Snapshot of AWRITES

PIB8.

188

Binary

8

Snapshot of AWRITES1

PIB8.

196

Binary

8

Async reads total time

PIB8.

204

Binary

8

Snapshot of ARTIME

PIB8.

212

Binary

8

Snapshot of ARTIME1

PIB8.

220

Binary

8

Async writes total time

PIB8.

228

Binary

8

Snapshot of AWTIME

PIB8.

236

Binary

8

Snapshot of AWTIME1

PIB8.

244

Binary

8

Async reads total pages

PIB8.

252

Binary

8

Snapshot of ARPAGES

PIB8.

260

Binary

8

Snapshot of ARPAGES2

PIB8.

268

Binary

8

Async write total pages

PIB8.

276

Binary

8

Snapshot of AWPAGES

PIB8.

284

Binary

8

Snapshot of AWPAGES2

PIB8.

292

Binary

4

Page size

PIB4.

296

Char

1

Statistics reset ‘y’

$1.

297

Char

43

Reserved


Snapshot utilities statistics section


00

Binary

4

Length of Section

PIB4.

04

Binary

4

Object ID (snapshot = 158)

PIB4.

08

Binary

4

Reserved

NA

12

Binary

4

Reserved

NA

16

Binary

4

Function

PIB4.

20

Binary

4

Return code

PIB4.

24

Binary

4

Reason code

PIB4.

28

Binary

4

ASID

PIB4.

32

Binary

4

TCB

PIB4.

36

Char

9

Component name

$8.

45

Char

45

Data set name

$44.

90

Char

5

XBM SSID

$4.

95

Char

9

User jobname

$8.

104

Char

9

User stepname

$8.

113

Char

9

User ID

$8.

122

Char

1

Compression

$1.

123

Binary

4

Priority

PIB4.

127

Binary

4

Allocated

PIB4.

131

Binary

4

Used bytes

PIB4.

135

Binary

4

Limit size

PIB4.

139

Binary

8

Percent used

PIB8.

147

Binary

8

Blocks

PIB8.

155

Binary

8

Active reads

PIB8.

163

Binary

8

Read hits

PIB8.

171

Binary

8

Read hit ratio

PIB8.

179

Binary

8

Writes

PIB8.

187

Binary

8

Cache writes

PIB8.

195

Binary

8

Maximum cache bytes

PIB8.

203

Char

5

Db2 SSID

$4.

208

Binary

4

RBA maintained by XBM

PIB4.

212

Binary

4

RBA maintained by user

PIB4.

VSAM statistics section

00

Binary

4

Length of section

PIB4.

04

Binary

4

Object ID (VSAM=199)

PIB4.

08

Binary

4

Reserved

NA

12

Binary

4

Reserved

NA

16

Binary

1

Compression

PIB1.

20

Binary

4

Control interval size

PIB4.

24

Binary

4

Control intervals per control area

PIB4.

28

Binary

4

Share option 1

PIB4.

32

Binary

4

Share option 2

PIB4.

36

Char

96

Reserved

NA

132

Binary

8

Direct reads

PIB8.

140

Binary

8

Snapshot direct reads 1

PIB8.

148

Binary

8

Snapshot direct reads 2

PIB8.

156

Binary

8

Direct writes

PIB8.

164

Binary

8

Snapshot direct writes 1

PIB8.

172

Binary

8

Snapshot direct writes 2

PIB8.

180

Binary

8

Direct reads time

PIB8.

188

Binary

8

Snapshot direct reads 1 time

PIB8.

196

Binary

8

Snapshot direct reads 2 time

PIB8.

204

Binary

8

Direct writes time

PIB8.

212

Binary

8

Snapshot direct writes 1 time

PIB8.

220

Binary

8

Snapshot direct writes 2 time

PIB8.

228

Binary

8

Sequential reads

PIB8.

236

Binary

8

Snapshot sequential reads 1

PIB8.

244

Binary

8

Snapshot sequential reads 2

PIB8.

252

Binary

8

Sequential writes

PIB8.

260

Binary

8

Snapshot sequential writes 1

PIB8.

268

Binary

8

Snapshot sequential writes 2

PIB8.

276

Binary

8

Sequential reads time

PIB8.

284

Binary

8

Snapshot sequential reads 1 time

PIB8.

292

Binary

8

Snapshot sequential reads 2 time

PIB8.

300

Binary

8

Sequential writes time

PIB8.

308

Binary

8

Snapshot sequential writes 1 time

PIB8.

316

Binary

8

Snapshot sequential writes 2 time

PIB8.

324

Binary

8

Sequential reads pages

PIB8.

332

Binary

8

Snapshot sequential read pages 1

PIB8.

340

Binary

8

Snapshot sequential read pages 2

PIB8.

348

Binary

8

Snapshot sequential write pages

PIB8.

356

Binary

8

Snapshot sequential write pages 1

PIB8.

364

Binary

8

Snapshot sequential write pages 2

PIB8.

372

Char

1

Statistics reset flag ‘y’

$1.

373

Char

1

VSAM retain attribute

$1.

374

Char

2

Reserved

NA

376

Binary

1

VSAM attributes

PIB1.

377

Binary

1

VSAM strings

PIB1.

378

Binary

4

IMS dbrc usage indicator

PIB4.

382

Binary

4

Number of buffers

PIB4.

386

Binary

8

VSAM statistics

PIB8.

394

Binary

4

Number of index levels

PIB4.

398

Binary

4

VSAM extents

PIB4.

402

Binary

4

Number of user records

PIB4.

406

Binary

4

Deleted records

PIB4.

410

Binary

4

Inserted records

PIB4.

414

Binary

4

Updated records

PIB4.

418

Binary

4

Number of retrieved records

PIB4.

422

Binary

4

Bytes of freespace

PIB4.

426

Binary

4

VSAM control interval splits

PIB4.

430

Binary

4

VSAM control area splits

PIB4.

434

Binary

4

EXCPs issued

PIB4.

438

Char

48

Reserved

NA

Extended prefetch statistics section

00

Binary

4

Length of section

PIB4.

04

Binary

4

Object ID (PSS=272)

PIB4.

08

Binary

8

Reserved

NA

16

Binary

4

Buffer space allocated

PIB4.

20

Binary

4

Number of buffer acquisitions

PIB4.

24

Binary

4

Number of buffer acquisition attempts

PIB4.

28

Binary

32

Reserved


60

Binary

8

Blocks read by Prefetch

PIB8.

68

Binary

8

Blocks read by application while Prefetch active

PIB8.

76

Binary

8

Blocks satisfied by Prefetch

PIB8.

84

Binary

8

Physical I/O requests by Prefetch

PIB8.

92

Binary

4

Return Code

PIB4.

96

Binary

4

Reason Code

PIB4.

100

Binary

20

Reserved

NA

IMS statistics section

00

Binary

4

Length of Section

PIB4.

04

Binary

4

Object ID (IMS DSN=242)

PIB4.

08

Binary

4

Reserved

NA

12

Binary

4

Reserved

NA

16

Char

1

Statistics reset

$1.

17

Char

1

Data set type

$1.

18

Char

1

Compression type key

$1.

19

Char

1

Reserved

$1.

20

Binary

4

Block size

PIB4.

24

Char

20

Reserved

NA

44

Binary

4

Control interval size

PIB4.

48

Binary

4

Control area size

PIB4.

52

Binary

4

Share option 1

PIB4.

56

Binary

4

Share option 2

PIB4.

60

Binary

8

Direct read SIOs

PIB8.

68

Binary

8

Snapshot of DREAD

PIB8.

76

Binary

8

Snapshot of DREAD1

PIB8.

84

Binary

8

Direct write SIOs

PIB8.

92

Binary

8

Snapshot of DWRITES

PIB8.

100

Binary

8

Snapshot of DWRITES1

PIB8.

108

Binary

8

Direct reads total time

PIB8.

116

Binary

8

Snapshot of DRTIME

PIB8.

124

Binary

8

Snapshot of DRTIME1

PIB8.

132

Binary

8

Direct writes total time

PIB8.

140

Binary

8

Snapshot of DWTIME

PIB8.

148

Binary

8

Snapshot of DWTIME1

PIB8.

156

Binary

8

Sync read SIOs

PIB8.

164

Binary

8

Snapshot of SREAD

PIB8.

172

Binary

8

Snapshot of SREAD1

PIB8.

180

Binary

8

Sync write SIOs

PIB8.

188

Binary

8

Snapshot of SWRITE

PIB8.

196

Binary

8

Snapshot of SWRITE1

PIB8.

204

Binary

8

Sync reads total time

PIB8.

212

Binary

8

Snapshot of SRTIME

PIB8.

220

Binary

8

Snapshot of SRTIME1

PIB8.

228

Binary

8

Sync writes total time

PIB8.

236

Binary

8

Snapshot of SWTIME

PIB8.

244

Binary

8

Snapshot of SWTIME1

PIB8.

252

Binary

8

Sync read total pages

PIB8.

260

Binary

8

Snapshot of SRPAGE

PIB8.

268

Binary

8

Snapshot of SRPAGE1

PIB8.

276

Binary

8

Sync writes total pages

PIB8.

284

Binary

8

Snapshot of SWPAGE

PIB8.

292

Binary

8

Snapshot of SWPAGE1

PIB8.

Was this page helpful? Yes No Submitting... Thank you

Comments