DB2 DSNDQBST buffer manager statistic block

Document ID : KB000047635
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What MICS file contains information from the DB2 DSNDQBST buffer manager statics block?

 

Answer:

The fields in the DB2 buffer manager statistics block macro 'DSNDQBST' located in 'db2hlq.SDSNMACS'

are stored in the DBPDSB file 'DB2 BUFFER POOL ACTIVITY'.  All of the fields in this DB2 macro start with QBSxxxx. 

You can search your 'sharedpefix.DIC.TEXT' dataset for the names of the DB2 fields to find which MICS element contains this info. 

For example, the QBSTGET field in in the DSNDQBST macro is mapped to DSBDBPR in the DBPDSB file.