Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
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.
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.
| 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
IDAGDTLR view
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.
Related topic