IBM DB2 RDBMS - Reports & Attributes
Attributes
The following attributes are available for IBM DB2 RDBMS
IBM DB2 RDBMS
Default Attributes
- name
- short_name
- product_version
- key
- type = IBM DB2 Database Server
- version
Optional Attributes
- revision
- service_pack
- edition
- instance
Additional Attributes
- port
- protocols
- copy_name - DB2 instance's alias name (for Windows systems only)
- product_dir
- secure_port
Feature Detail Node
Default attributes
- type = Enabled Feature
- name
- expiration_date
Additional attributes
- product_identifier
License Detail Node
Default attributes
- expiration_date
- type = Licensing Detail
- name
Additional attributes
- product_name
- license_type
- product_identifier
- version
- max_users
- allowed_cpus
- licensed_cpus
Reports
In TKU March 2011 the DB2 pattern was updated and DB2 Features support had been added to its functionality. The following images show DB2 Features in DB2 SoftwareInstance view, as well as their attributes:
To find all discovered DB2 Features, their parent DB2 Software Instances and expiration date the following generic query should be launched on the ADDM:
TRAVERSE ElementWithDetail:Detail:Detail:Detail WHERE type = 'Enabled Feature'
SHOW name AS 'Detail name', #Detail:Detail:ElementWithDetail:SoftwareInstance.name AS 'Related DB2 SI name', expiration_date AS 'Expiration date'
In TKU August 2012 the DB2 pattern was updated and DB2 Database Details support had been added to its functionality by the extended pattern. Now the pattern models Database Details which contain Schema Details which in their turn store Table Details.
To get the list of all Database Nodes and underlying Schemas the following generic query should be implemented on the appliance:
SEARCH SoftwareInstance WHERE type = 'IBM DB2 Database Server'
TRAVERSE ElementWithDetail:Detail:Detail:DatabaseDetail WHERE type = 'DB2 Database Server Database'
SHOW name AS 'Database name', database_alias AS 'Database alias', #Detail:Detail:ElementWithDetail:SoftwareInstance.name AS 'Related DB2 SI name', #Container:Containment:Contained:DatabaseDetail.name AS 'Contained Schemas'Go Back To Product Page