1. Non Oracle Database Management Reference Manual
  2. IBM DB2 Database Metrics
  3. Database Manager Configuration Information

Database Manager Configuration Information

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:

Capacity

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 3-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).

Connection

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 3-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.

Database Instance

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 3-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:

  • 0 — No messages

  • 1 — Fatal or unrecoverable errors

  • 2 — All Immediate action required messages

  • 3 — All Important information (no immediate action required)

Otherwise, All Informational messages.

CPU Speed

CPU speed in MIPs, which equals:

1/(cpuspeed_raw*1000)

Logging and Recovery

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 3-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.

Partitioned Database Environment

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 3-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.