Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Using online reports

As you navigate from one report to another, identifiers displayed in the report header help you keep track of the selections that you made on your way to the current report.

In the following example, the identifiers show the statement list for table RDADMB.DMBTBDYN1, which is running on Db2 subsystem DECX.

 

Related topic

Using the Index Component

Example
                                                   ASQEQRPW/I                      View a Report                    LINE 1 OF 690                                                  
Command ====> _______________________________________________ Scroll ===> CSR_                                                  
                                                                                                                               
BMCSftwr.IODSTMTS    --         STATEMENT LIST         --       11/22 16:28:18                                                  
Source : DOMS-ACTIVE   Intvl : 11/22 16:10 - UNLIMITED          More:     +                                                     
--------------------------------------------------------------------------------------------------------------------------
   Actions: B-Table/Index Breakdown T-SQL Text                                                                 
                                                                                                                             
   Logical DB2 Name: DECX     Table Creator: RDADMB   Table Name: DMBTBDYN1                                                     
                                                                                                                          
                                 +---------- Getpage ---------+ +- Sync I/O --+ +-- Async I/O --+      SQL Statement           
   Plan     Program  Sect. Stmt#   Number Index%  /Stmt AvgTime  Number AvgTime   Number    Pages    Calls Type                
   -------- -------- ----- ----- -------- ------ ------ ------- ------- ------- -------- -------- -------- -----------------
+  DYNSQL   DYNSQL       2   283      356   0.0%    4.0 0.00000       0 0.00000        0        0       89 DELETE              
+  DYNSQL   DYNSQL       2   283      356   0.0%    4.0 0.00000       0 0.00000        0        0       89 DELETE              
C  DYNSQL   DYNSQL       1   180      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 CURSOR              
+  DYNSQL   DYNSQL       2   283      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 DELETE              
+  DYNSQL   DYNSQL       2   229      267   0.0%    3.0 0.00001       0 0.00000        0        0       89 UPDATE              
+  DYNSQL   DYNSQL       1   180      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 CURSOR              
+  DYNSQL   DYNSQL       2   229      267   0.0%    3.0 0.00001       0 0.00000        0        0       89 UPDATE              
+  DYNSQL   DYNSQL       2   283      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 DELETE              
+  DYNSQL   DYNSQL       2   283      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 DELETE              
+  DYNSQL   DYNSQL       1   180      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 CURSOR              
+  DYNSQL   DYNSQL       1   180      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 CURSOR              
+  DYNSQL   DYNSQL       2   283      267   0.0%    3.0 0.00001       0 0.00000        0        0       89 DELETE              
+  DYNSQL   DYNSQL       2   229      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 UPDATE              
+  DYNSQL   DYNSQL       3   242      267   0.0%    3.0 0.00000       0 0.00000        0        0       89 UPDATE

 

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