Reporting from Db2 tables
You can alter the supplied queries or create others for specific reporting requirements, or use any in-house Db2 query tool. As voluminous accounting data is usually summarized before loading, reports for longer time periods are easier to produce from the raw input data.
All DPCSxxxx (Create Tablespace) and DPCTxxxx (Create Table) members have been updated to specify DEFINE NO for the creation of the tablespaces and indexes.
When using DEFINE NO the data sets are not created until data is inserted into the tablespace.
DEFINE NO is applicable only for Db2-managed data sets (USING STOGROUP is specified). DEFINE NO is ignored for user-managed data sets (USING VCAT is specified). Db2 uses the SPACE column in catalog table SYSTABLEPART to record the status of the data sets (undefined or allocated).
The following table lists by default the name of each of the tables that can be created in Performance Reporter, and the related BBPARM and BBSAMP members.
Default table name and description | Default table space name | Create table space/table member (UBBSAMP) | Report members (BBPARM) |
|---|---|---|---|
DMRPR.DMRACDTL (Accounting table—detail) | DMRPRTAD | DPCSACDT DPCTACDT | ACxxxxxx |
DMRPR.DMRACSUM (Accounting table—summary) | DMRPRTAS | DPCSACSM DPCTACSM | SAxxxxxx |
DMRPR.DMRACSM2 (Accounting table—summary–2) | DMRPRTA2 | DPCSACS2 DPCTACS2 | SAxxxxxx |
DMRPR.DMRAXDTL (Accounting Accelerator table—detail) | DMRPRXAD | DPCTAXDT | Not applicable |
DMRPR.DMRAXSUM (Accounting Accelerator table—summary) | DMRPRXAS | DPCTAXSM | Not applicable |
DMRPR.DMRAXSM2 (Accounting Accelerator table—summary)–2 | DMRPRXA2 | DPCTAXS2 | Not applicable |
DMRPR.DMRAUSUM (Audit summary table) | DMRPRAUS | DPCSAUSM DPCTAUSM | AUSUM AUDTL |
DMRPR.DMRAUGRV (Authorization control—GRANTs/REVOKEs table) | DMRPRAUG | DPCSAUGR DPCTAUGR | AUDGRV |
DMRPR.DMRAUFAL (Authorization failures table) | DMRPRAUF | DPCSAUFL DPCTAUFL | AUFAIL |
DMRPR.DMRAUCHG (Authorization ID change table) | DMRPRAUC | DPCSAUCH DPCTAUCH | AUCHNG |
DMRPR.DMRABDTL (Buffer accounting table—detail) | DMRPRTID | DPCSABDT DPCTABDT | ACxxxxxx |
DMRPR.DMRABSUM (Buffer accounting table—summary) | DMRPRTIS | DPCSABSM DPCTABSM | SAxxxxxx |
DMRPR.DMRABSM2 (Buffer accounting table—summary–2) | DMRPRTI2 | DPCSABS2 DPCTABS2 | SAxxxxxx |
DMRPR.DMRSBFDT (Buffer statistics table—detail) | DMRPRTBD | DPCSSBDT DPCTSBDT | STxxxxx |
DMRPR.DMRSBSUM (Buffer statistics table—summary) | DMRPRTBS | DPCSSBSM DPCTSBSM | SSxxxxx |
DMRPR.DMRSBSM2 (Buffer statistics table—summary–2) | DMRPRTB2 | DPCSSBS2 DPCTSBS2 | SSOVDFT SSOVRxx |
DMRPR.DMRADDTL (DDF accounting table—detail) | DMRPRTDD | DPCSADDT DPCTADDT | ACxxxxx |
DMRPR.DMRADSUM (DDF accounting table—summary) | DMRPRTDS | DPCSADSM DPCTADSM | SAxxxxxx |
DMRPR.DMRADSM2 (DDF accounting table—summary–2) | DMRPRTD2 | DPCSADS2 DPCTADS2 | SAxxxxxx |
DMRPR.DMRSTDF (DDF statistics table—detail) | DMRPRTSF | DPCSSTSD DPCTSTSD | STOVDFT |
DMRPR.DMRSDSUM (DDF statistics table—summary) | DMRPRTFS | DPCSSFSM DPCTSFSM | STOVDFT |
DMRPR.DMRSDSM2 (DDF statistics table—summary–2) | DMRPRTF2 | DPCSSFS2 DPCTSFS2 | SSxxxxx |
DMRPR.DMRAUDDL (DDL access table) | DMRPRAUD | DPCSAUDL DPCTAUDL | AUDDL |
DMRPR.DMRAUDML (DML access table) | DMRPRAUM | DPCSAUDM DPCTAUDM | AUDML |
DMRPR.DMRAUDMB (DML at BIND table) | DMRPRAUB | DPCSAUDB DPCTAUDB | AUDMLB |
DMRPR.DMRDGPDT1 (Dynamic and group buffer pool attribute table—detail) | DMRPRDGD | DPCSDGDT | Not applicable |
DMRPR.DMRAUFTB (Fast index traversal table—detail) | DMRPRAFI | DPCSAUFI DPCTAUFI | Not Applicable |
DMRPR.DMRAUIFE (Incompatible functions executed table—detail) | DMRPRAIC | DPCSAUIC DPCTAUIC | Not Applicable |
DMRPR.DMRAPDTL (Package accounting table—detail) | DMRPRTPD | DPCSAPDT DPCTAPDT | ACxxxx |
DMRPR.DMRAPSUM (Package accounting table—summary) | DMRPRTPS | DPCSAPSM DPCTAPSM | SAxxxx |
DMRPR.DMRAPSM2 (Package accounting table—summary–2) | DMRPRTP2 | DPCSAPS2 DPCTAPS2 | SAxxxx |
DMRPR.DMRSXDTL (Statistics Accelerator table—detail) | DMRPRXSD | DPCTSXDT | Not applicable |
DMRPR.DMRSXSUM (Statistics Accelerator table—summary) | DMRPRXSM | DPCTSXSM | Not applicable |
DMRPR.DMRSXSM2 (Statistics Accelerator table—summary–2) | DMRPRXS2 | DPCTSXS2 | Not applicable |
DMRPR.DMRSTAT (Statistics table—detail) | DMRPRTSS | DPCSSTDT DPCTSTDT | STxxxxxx |
DMRPR.DMRSTSUM (Statistics table—summary) | DMRPRTTS | DPCSSTSM DPCTSTSM | SSxxxxxx |
DMRPR.DMRSTSM2 (Statistics table—summary–2) | DMRPRTT2 | DPCSSTS2 DPCTSTS2 | SSxxxxx |
DMRPR.DMRSTADT (Storage address space table) | DMRSTADT | DPCTSADT | Not applicable |
DMRPR.DMRSTSDT (Storage system table) | DMRSTSDT | DPCTSSDT | Not applicable |
DMRPR.DMRAUUTL (Utility access table) | DMRPRAUU | DPCSAUUT DPCTAUUT | AUUTIL |
DMRPR.DMRAURLS | DMRPRALS | DPCSAULS DPCTAULS | Not applicable |
| DMRPR.DMRAULAP | DMRPRLAP | DPCSAUAP DPCSAUAP | Not applicable |
| DMRPR.DMRAULAU | DMRPRLAU | DPCSAUAU DPCSAUAU | Not applicable |
- Add the DMRPR.DMRDGPDT table only if you require the dynamic and group buffer pool attribute data. The dynamic buffer pool attribute (IFCID 202) and group buffer pool attribute (IFCID 230) contain a large volume of data. Loading the data into this table results in high CPU and DASD space consumption.