Partition Table

View a list of all partitions on a database, performance metrics for each partition, as well as setup details such as the product associated with the partition and service level.

Use this display to investigate partitioning issues on a database. Select an Instance and a Database. Sort the list by column values such as DB2 Status, Rollbacks per second and many others.

db2_Db_parts.gif

title_bar_shortNew00070.gif

 

Database Partitions Table

Each row is a different partition on the selected database. Column values describe the partition.

Instance:

Select an instance.

Database:

Select a database.

 

Partition #

The partition number.

 

Expired

When checked, performance data has not been received within the time specified by your administrator for the Expire Time.

If your administrator has also set the Delete Time, this row will be deleted if no data is received within the time specified for deletion.

 

DB2 Status

The current DB2 status. For example, ACTIVE.

 

DB Status

The current database status. For example, ACTIVE.

 

DB Start Time

The date and time the database was last started.

 

Local Cons

The number of local connections.

 

Remote Cons

The number of remote connections.

 

App Cur Cons

The number of currently connected applications.

 

SQL Faults/sec

The number of SQL faults per second.

 

Rows Read /sec

The number of rows read per second.

 

Rows Selected /sec

The number of rows selected per second.

 

Rows Changed /sec

The number of rows changed per second.

 

SQL Selects /sec

The number of SQL selects per second.

 

Commits /sec

The number of commits per second.

 

Rollbacks /sec

The number of rollbacks per second.

 

Update/Del/Ins/Stmts /sec

The number of updates, deletions, insertions and statements per second.

 

Avg Sort Time/Transaction

The average amount of time for sorting transactions.

 

Product Name

The name of the product.

 

Service Level

The service level for the product.

 

Pool Data Hit Ratio

The current buffer pool hit ratio, which is the total number of pool hits divided by the total number of buffer pool lookups.

 

Pool TmpData Hit Ratio

Refer to vendor documentation for details.

 

Pool TmpIndex Hit Ratio

Refer to vendor documentation for details.

 

Pkg Cache Inserts/K-Trans

Refer to vendor documentation for details.

 

Lock Wait Time/K-Trans

Refer to vendor documentation for details.

 

Dirty Steal Triggers/K-Trans

Refer to vendor documentation for details.

 

Deadlocks & Lock Timeouts/K-Tran

Refer to vendor documentation for details.

 

Avg Log Write Time / Trans

Refer to vendor documentation for details.

 

% Agent Usage

The percentage used by agents.

 

Agents Registered (Top)

The number of registered agents.

 

Rows Read Returned Ratio

The number of rows read per number of rows returned.

 

Select %

Refer to vendor documentation for details.

 

Phys Buffer Pool Read Ratio

Refer to vendor documentation for details.

 

Phys Buffer Pool Write Ratio

Refer to vendor documentation for details.