Skip to Content

Object analysis reports

Object analysis reports are a subset of the Workload Analysis reports.

They are used to collect and analyze information about access, usage, and response times for Db2 buffer pools, databases, page sets, tables, and indexes.

You can approach object data in a number of ways:

  • Examining object data for a specific workload
  • Examining object data that is associated with a specific SQL statement
  • Starting at the Db2 subsystem level, and navigating from a buffer pool, database, or page set all of the way down to a specific table or index

Related topic

Workload-analysis-reports

The following figure is an example of the Table Access Summary report, displaying the tables for a selected Db2 subsystem. For examples that use object reports, see Buffer-Pool-Analysis-report-example. 

Information
Example
ASQEQRPW/I                      VIEW A REPORT                    LINE 1 OF 175                                                     
COMMAND ====> _______________________________________________ SCROLL ===> CSR_                                                     
                                                                                                                                  
BMCSftwr.SQMSOBJT    --      TABLE ACCESS SUMMARY      --       01/28 17:36:57                                                     
SOURCE : DAC1-ACTIVE   INTVL : 01/28 16:19 - UNLIMITED          MORE:     +                                                        
-----------------------------------------------------------------------------------------------------------------------------
ACTIONS:  T-TABLE AND INDEX C-CONNID          R-PROGRAM         U-USER            H-HEADER                                      
          M-ACCESS MATRIX   I-CORRID          P-PLAN            S-STMT            N-PARTITIONS                                  
                                                                                                                               
DB2: DEDK   BUFFER POOL:          DATABASE:                                                                                   
                                                                                                                                
TABLE                                BPOOL   +--------- GETPAGE -----------+  +------- SYNC I/O ------+  +- ASYNC I/O -+  MAX   
CREATOR   TABLE NAME         SUMMARY HRATIO  NUMBER  PCT   TOT TIME AVG TIME  NUMBER  TOT TIME  AVG TIME  REQUEST PAGES   PART  
--------  ------------------ ------- ------  ------ ----- --------- --------  ------ ---------  --------  ------- ------- ----  
+ SYSIBM   SYSTABLES          TAB+IND 99.9 %   1517K 23.1% 0:01.8937  00.0000    387 0:00.3695  00.0010       2     451    1
+ SYSIBM   SYSTABAUTH         TAB+IND  100 %   1516K 23.0% 0:01.3778  00.0000     21 0:00.1092  00.0052       0      24    1
+ RDADAC2  STMT_TEXT          TAB+IND 99.5 %  921295 14.0% 0:02.1402  00.0000   2716 0:01.0141  00.0004       0    2225    1
+ SYSIBM   SYSDATABASE        TAB+IND  100 %  677522 10.3% 0:00.6149  00.0000     13 0:00.0453  00.0035       0      43    1
+ SYSIBM   SYSSYNONYMS        TAB+IND 21.6 %  527319  8.0% 0:32.9004  00.0001  16387 0:07.2950  00.0004   26708  397174    1
+ SYSIBM   SYSTABLESPACE      TAB+IND 99.9 %  506053  7.7% 0:00.6586  00.0000    121 0:00.1719  00.0014       0     223    1
+ SYSIBM   SYSUSERAUTH        TAB+IND  100 %  505824  7.7% 0:00.4627  00.0000      4 0:00.0193  00.0048       0      34    1
+ SYSIBM   SYSINDEXES         TAB+IND  100 %  170831  2.6% 0:00.2496  00.0000     73 0:00.1087  00.0015       0       0    1
+ ATS101   RS_COLDISTSTAT     TAB+IND  0.1 %  127025  1.9% 0:08.5953  00.0001     11 0:00.0046  00.0004    7940  126831    1
+ RDADAC2  DAILY_STMT_STATI>> INDEX    0.0 %   66607  1.0% 0:02.3164  00.0000    424 0:00.2743  00.0006       0   79612    1
+ DSNDB07  DSN32K01           TABLE    3.3 %   10545  0.2% 0:01.9328  00.0002      2 0:00.0012  00.0006       0   10190    1

GUID-47E5A770-A760-442A-9F5A-06872981813D-low.png

For more information, view the Quick Course "Using SQL Performance Object Reports."


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Apptune for Db2 13.1