Database Activity Detail for a Data Sharing Group view (IDAGDTLR)

The Database Activity Detail for a Data Sharing Group view (IDAGDTLR) provides information about database I/O activity, and DL/I calls for a data sharing group.

You can use the IDAGDTLR view to analyze I/O information related to logical and physical databases. The view helps you recognize and solve N-way data sharing problems resulting from I/O contention or buffer cross-invalidation, and it shows DL/I call and I/O event totals, rates, and average times.

Related topic

Manage-IMS-database-activity

The IDAGDTLR view reports DEDB activity if the Event Collector parameter DBFPLVL is set to collect DEDB activity, but it does not report MSDB or GSAM database activity or activity caused by background write.

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

For more information, view the Quick Course 'MainView for IMS - Region and Database Activity'.

You can hyperlink to the IDAGDTLR view from the

  • Database Activity option in the IMS SSI Easy Menu (EZISSIR) and the DBCTL Operations Menu (EZDOPSR)
  • System DB Activity option in the DBCTL DBA Easy Menu (EZIDBA)
  • Data ShrGrp field in the IDASSUMR view

Important

Only IMS subsystems in your context are included in the count in the IDAGDTL/R Number of IMS Systems field. If any of the IMS subsystems in your data sharing group are not included in your context, the data in the field will be incomplete.

Database Activity Detail for a Data Sharing Group view (IDAGDTLR)

 Data Sharing Group......      NONE  Sample seconds...........              5.0
 IMS Name(s).............  I9A410CT                                            
 Number of IMS Systems...         1                                            
                                                                              
 --FULL FUNCTION DB I/O--            --- DATABASE CALLS ------                 
 Total        I/O Seconds      0.05  DL/I Call Total Seconds..            0.061
 Average      I/O Time...     0.002  DL/I Call AVG Time.......           0.0014
 Read         I/O AVG....     0.002  DL/I Call Rate...........             8.76
 Write        I/O AVG....     0.003  DL/I Call Percent I/O....            72.18
 Read         I/O Rate...      2.99  DL/I Call AVG NBR I/O....            0.523
 Write        I/O Rate...      1.20   DB GU    Rate...........             2.59
 Sync Write   I/O Rate...      1.20   DB GHU   Rate...........             1.59
 Read OSAM XI I/O Rate...      0.00   DB GN    Rate...........             0.00
                                      DB GNP   Rate...........             1.99
 --DEDB DATABASE I/O ----             DB GHN   Rate...........             0.00
 Total        I/O Seconds      0.04   DB GHNP  Rate...........             0.00
 Average      I/O Time...     0.003   DB ISRT  Rate...........             1.00
 Read         I/O AVG....     0.002   DB REPL  Rate...........             0.60
 OTHREAD      I/O AVG....     0.003   DB DLET  Rate...........             1.00
 Read         I/O Rate...      1.59   DB OTHER Rate...........             0.00
 OTHREAD      I/O Rate...      1.59  Databases with calls.....                4
                                                                              
 --ALL DATABASE I/O -----             --- BUFFER POOLS -------                 
 Databases    with I/O...         5  Worst VSAM Pool Hit Ratio             73.9
 Volumes      with I/O...         8  Worst OSAM Pool Hit Ratio             92.3

No hyperlinks are available on the view.


 

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