sys.zOS.DB2Subsystem
Db2® subsystems consist of several specialized address spaces components running on a z/OS® system. Each provide different Db2 services for the subsystem. Each subsystem has one address space known as the Master which regulates the Db2 subsystem as a whole.
Attributes marked with an asterisk (*) are discovered only when ENABLE_ZRDS are
enabled. For more information, see SET directive
Attributes
| CDM attribute | Value | Example |
| (Subsystem) SubsystemName | The 1-4 character name of the Db2 subsystem. | DB7A |
| (Subsystem) CommandPrefixName | A prefix used by support personnel to direct commands to the Db2 subsystem. | DB7A |
| (Subsystem) ControllingAddressSpace | The Jobname of the Master address space. This is needed to identify the address space to support personnel. | DB7AMSTR |
| (Subsystem) DDFLocation* | The Db2 DDF location information. | DB1B |
| (Subsystem) VersionString | Db2 Version Release and Modification level. | 8.1.0 |
| SysDatabaseMaxAlteredTs | Maximum ALTEREDTS value for the SYSIBM.SYSDATABASE table. This attribute enables changes to the SYSDATABASE catalog to be tracked. | datestamp |
| SysTableSpaceMaxAlteredTs | Maximum ALTEREDTS value for the SYSIBM.SYSTABLESPACE table. This attribute enables changes to the SYSTABLESPACE catalog to be tracked. | datestamp |
| SysTablesMaxAlteredTs | Maximum ALTEREDTS value for the SYSIBM.SYSTABLES table. This attribute enables changes to the SYSTABLES catalog to be tracked. | datestamp |
| SysIndexesMaxAlteredTs | Maximum ALTEREDTS value for the SYSIBM.SYSINDEXES table. This attribute enables changes to the SYSINDEXES catalog to be tracked. | datestamp |
| SysColumnsMaxAlteredTs | Maximum ALTEREDTS value for the SYSIBM.SYSCOLUMNES table. This attribute enables changes to the SYSCOLUMNS catalog to be tracked. | datestamp |
Requirements for discovery
- Db2 subsystem book has all attributes and all relationships except AddressSpaces.
- ZOSTASK book has naming rules and relationships to AddressSpaces.
- Filtering enabled (which is the default).
- Db2 subsystem and related address spaces must be active and fully initialized.
- Attributes and relationships are marked with an asterisk (*) are discovered only when the DLA runs in authorized mode.
- The user ID running the DLA must have authority to issue the Db2
DISPLAY DB(*)andDISPLAY GROUP(*)commands. - The user ID that run the DLA must have read access to the following Db2 Tables:
- SYSIBM.SYSDATABASE for SysdatabaseMaxAlterdts attribute
- SYSIBM.SYSTABLESPACE for SystablespaceMaxAlterdts attribute
- SYSIBM.SYSTABLES for SystablesMaxAlterdts attribute
- SYSIBM.SYSINDEXES for SysindexesMaxAlterdts attribute
- SYSIBM.SYSCOLUMNS for SyscolumnsMaxAlterdts attribute
- Rexx bind for DSNREXX interface must be run for Sys* attributes.
CDM specific information
| CDM Naming Policy | sys.zOS.DB2Subsystem | |
| CDM Attribute | Value | Example |
| Label | SubsystemName-SMFID | DB7A-OMO1 |
| id (IdML) | SubsystemName- SMFID-DB2Subsystem | DB7A-OMO1-DB2Subsystem |
| sourceToken (IdML) | SubsystemName- SMFID-DB2Subsystem | DB7A-OMO1-DB2Subsystem |
Naming rules
SubsystemName and hostedDependency relationship to zOS.
Relationships
| Link type | Source | Target | Comment |
|---|---|---|---|
| hostedDependency | sys.zOS.DB2Subsystem | sys.zOS.ZOS | Part of a primary naming rule a long with SubsystemName attribute. |