Database Manager Configuration Information metrics describe a set of database manager configuration parameters. These values are of two types: in hard disk and in memory, which is the type presented here. Database Manager Configuration Information metrics consist of the following categories:
The metrics in this category return the database manager capacity configuration parameters that can impact the throughput on your system.
Table Name — MGMT_EMX_IBMDB2_DBMCAP
View Name — MGMT_EMX_IBMDB2_DBMCAP_VIEW
Default Collection Interval — Every 24 hours
Table 2-3 Capacity Metrics
Metric | Description |
---|---|
Application Support Layer Size |
The application support layer heap represents a communication buffer between the local application and its associated agent. |
Database System Monitor Heap Size |
Determines the amount of memory, in pages, to allocate for database monitor data. |
Audit Buffer Size |
Specifies the size of the buffer used when auditing the database. |
Maximum Java Interpreter Heap Size |
Determines the maximum size of the heap used by the Java interpreter started to service Java DB2 stored procedures and UDFs. |
Maximum Total Files Open |
Defines the maximum number of files that can be opened by all agents and other threads executing in a single database manager instance. |
Priority of Agents |
Controls the priority the operating system scheduler gives to all agents and other database manager instance processes and threads. |
Maximum Number of Agents |
Indicates the maximum number of database manager agents, whether coordinator agents or subagents, available at any given time to accept application requests. |
Maximum Number of Concurrent Agents |
Maximum number of database manager agents that can concurrently execute a database manager transaction. |
Agent Pool Size |
Determines the maximum size of the idle agent pool. |
Initial Number of Agents in Pool |
Determines the initial number of idle agents created in the Agentpool at DB2START time. |
Sort Heap Threshold |
The size of the shared sort memory is statically predetermined at the time of the first connection to a database based on the value of the sort heap threshold configuration parameter (sheapthreas). |
The metrics in this category return the parameters that provide information about using DB2 in a client/server environment.
Table Name — MGMT_EMX_IBMDB2_DBMCON
View Name — MGMT_EMX_IBMDB2_DBMCON_VIEW
Default Collection Interval — Every 24 hours
Table 2-4 Connection Metrics
Metric | Description |
---|---|
TCP/IP Service Name |
Contains the name of the TCP/IP port that a database server uses to communicate to the client. |
Search Discovery Communications Protocols |
From an administration server perspective, this metric defines the search discovery managers started when DB2ADMIN starts. |
The metrics in this category return the parameters that provide information about database manager instances.
Table Name — MGMT_EMX_IBMDB2_DBMDBINST
View Name — MGMT_EMX_IBMDB2_DBMDBINST_VIEW
Default Collection Interval — Every 24 hours
Table 2-5 Database Instance Metrics
Metric | Description |
---|---|
Diagnostic Error Capture Level |
Determines the type of diagnostic errors recorded in the db2diag.log file. |
Diagnostic Directory Data Path |
Enables you to specify the fully qualified path for DB2 diagnostic information. |
Notify Level Raw |
Specifies the type of administration notification messages written to the administration notification log. |
Default Database System Monitor Switches |
Unique metric that enables you to set several switches, each of which are internally represented by a bit of the metric. |
Communications Bandwidth |
Value calculated for the communications bandwidth in MB per second. |
CPU Speed Raw |
The CPU speed, in milliseconds per instruction, used by the SQL optimizer to estimate the cost of performing certain operations. |
Maximum Number of Concurrently Active Databases |
Specifies the number of local databases that can be concurrently active. |
System Administration Authority Group Name |
Defines the group name with SYSADM authority for the database manager instance. |
Notify Level |
If notifylevel_raw equals:
Otherwise, All Informational messages. |
CPU Speed |
CPU speed in MIPs, which equals: 1/(cpuspeed_raw*1000) |
The metrics in this category save the logging and recovery information. Recovering your environment can be very important to prevent the loss of critical data. A number of parameters are available to help you manage your environment and to ensure that you can adequately recover your data or transactions.
Table Name — MGMT_EMX_IBMDB2_DBMLOGREC
View Name — MGMT_EMX_IBMDB2_DBMLOGREC_VIEW
Default Collection Interval — Every 24 hours
Table 2-6 Logging and Recovery Metrics
Metric | Description |
---|---|
Transaction Manager Database Name |
Identifies the name of the transaction manager (TM) database for each DB2 instance. |
Transaction Resync Interval |
Specifies the time interval in seconds for which a transaction manager (TM), resource manager (RM), or sync point manager (SPM) should retry the recovery of any outstanding transactions in doubt found in the TM, RM, or SPM. |
Sync Point Manager Name |
Identifies the name of the sync point manager (SPM) instance to the database manager. |
Sync Point Manager Log File Size |
Identifies the sync point manager (SPM) log file size in 4 KB pages. |
Sync Point Manager Resync Agent Limit |
Identifies the number of agents that can simultaneously perform resync operations. |
The metrics in this category return parameters about parallel operations and partitioned database environments.
Table Name — MGMT_EMX_IBMDB2_DBMPARENV
View Name — MGMT_EMX_IBMDB2_DBMPARENV_VIEW
Default Collection Interval — Every 24 hours
Table 2-7 Partitioned Database Environment Metrics
Metric | Description |
---|---|
Connection Elapsed Time |
Specifies the number of seconds within which a TCP/IP connection is to be established between two database partition servers. |
Number of FCM Buffers |
Specifies the number of 4 KB buffers used for internal communications (messages) both among and within database servers. |
Node Connection Retries |
max_connretries specifies the number of connection retries that can be made to a database partition server. |
Maximum Time Difference Among Nodes |
Each database partition server has its own system clock. This metric specifies the maximum time difference, in minutes, that is permitted among the database partition servers listed in the node configuration file. |
Start and Stop Timeout |
Applicable only in a partitioned database environment. |