Db2 Sorts Test

This test, executed by an internal agent, tracks various statistics pertaining to the sorts in a DB2 UDB database. The details of the test are provided below:

Target of the test : A DB2 database server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every database being monitored

Configurable parameters for the test
  1. TEST PERIOD – How often should the test be executed
  2. HostThe IP address of the DB2 server
  3. PortThe port number through which the DB2 server communicates. The default port is 50000.
Measurements made by the test:
Measurement Description Measurement Unit Interpretation

Avg sort time:

Indicates the average sort time for all sorts performed by all applications connected to a particular database.

Ms/Sort

A high value can point to a database with possible sorting problem (for example, applications are spending too much time on sorts). See the SORT screen for this database. The sort information for this database manager should also be looked at instance level.

It may be necessary to increase the SORTHEAP configuration parameter.

Percent Sort Overflow:

Denotes the percentage of sorts that overflowed.

Percent

Sort overflows are sorts that ran out of sort heap and required disk space for temporary storage. These sorts are not efficient, and when the value of this measure is consistently high for a number of intervals, then, it may be necessary to increase the SORTHEAP configuration parameter.