ER - Add APM for Mainframe DSAIED/DSAIEDA Metrics
Article ID: 374461
Updated On:
Products
Issue/Introduction
ER Request:
How I can add some new metrics I stumbled across added to APM?
DSAIED - STORAGE STATISTICS DETAIL
DSAIEDA - ADDRESS SPACE STORAGE STATISTICS DETAIL
With DSAIED, I can map out the QW0225_REALAVAIL IFCID and provide a nice graph of the memory Db2 has available.
Follow up email - note I found the included table at https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/archive-tables/subsystem-archive-tables/storage-utilization/subsys-storage-detail-table.html
Here are the fields in question for DSAIED that I am currently looking to have available in APM:
|
Db2 Column Name |
Characteristics |
IQL Field Name |
Db2 Field Name |
Field Description |
|
ACT_DISCONN_DBATS |
INTEGER |
ACT-DISCONN-DBATS |
QW0225DB |
Specifies the number of active and disconnected DBATs. |
|
ACTIVE_THREADS |
INTEGER |
ACTIVE-THREADS |
QW0225AT |
Number of active allied threads. |
|
QW0225_ECSA_ALLOC |
INTEGER |
QW0225_ECSA_ALLOC |
QW0225_ECSA_ALLOC |
(S) IBM serviceability field. |
|
QW0225_ESQA_ALLOC |
INTEGER |
QW0225_ESQA_ALLOC |
QW0225_ESQA_ALLOC |
(S) IBM serviceability field. |
|
QW0225_ESQAS |
INTEGER |
QW0225_ESQAS |
QW0225_ESQAS |
(S) IBM serviceability field. |
|
QW0225_REALAVAIL |
INTEGER |
QW0225_REALAVAIL |
QW0225_REALAVAIL |
(S) IBM serviceability field. |
|
REAL_64BIT_COM_DB2 |
BIGINT |
REAL-64BIT-COM-DB2 |
QW0225COMSTG_REAL |
Specifies the number of real 4K frames in use for 64-bit common storage. This is recorded at the subsystem level. |
|
REAL_64BIT_SHR_DB2 |
BIGINT |
REAL-64BIT-SHR-DB2 |
QW0225SHRSTG_REAL |
Specifies the number of real 4K frames in use for 64-bit shared storage. This does not include shared stack storage. This is recorded at the subsystem level. |
|
REAL_64BIT_SHR_LPAR |
BIGINT |
REAL-64BIT-SHR-LPAR |
QW0225SHRINREAL |
Specifies the number of 64-bit shared pages that are backed in real storage (4-KB pages) for this z/OS LPAR. |
|
REAL_64BIT_SHR_STK_DB2 |
BIGINT |
REAL-64BIT-SHR-STK-DB2 |
QW0225SHRSTKSTG_REAL |
Specifies the number of real 4K frames in use for 64-bit shared stack storage. This is recorded at the subsystem level. |
|
TOT_AL_DYN_SQL_STG |
BIGINT |
TOT-AL-DYN-SQL-STG |
QW0225SC8 |
Represents the total allocated 64-bit shareable storage that the dynamic SQL statements use. |
|
TOT_AL_STAT_SQL_STG |
BIGINT |
TOT-AL-STAT-SQL-STG |
QW0225SX8 |
Total allocated 64-bit shareable storage that static SQL statements use. |
Resolution
ER defect created --DE612204.
Feedback
