Db2 DPF Activity Test

This test measures the level of SQL activity on the logical partitions, and reveals how well the partitions process SQL queries.

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 logical partition of each database on the DB2 database server that is currently active

Configurable parameters for the test
TEST PERIOD – How often should the test be executed Host – The IP address of the DB2 server Port – The port number through which the DB2 server communicates. The default port is 50000. user - Specify the name of the user who has any of the following privileges to the specified DATABASE: SYSADM or SYSCTRL or SYSMAINT or SYSMON. You can create a separate user on the OS hosting the DB2 server for this purpose, and assign any of the aforesaid privileges to that user. The steps for the same are detailed in the Creating a Special User for Monitoring DB2. password - Enter the password of the specified USER in the PASSWORD text box. confirm password – Confirm the password by retyping it here. SSL- If the target database server is SSL-enabled, then set the SSL flag to Yes. If not, then set the SSL flag to No. Trust Store file name- The trust store file contains certificates from trusted Certificate Authorities (CAs). These certificates are used by eG agent to verify the authenticity of servers hosting DB2 UDB and establish a secure connection with the server using SSL. Specify the filename for Trust store file in Trust Store file name text box. Trust Store Password- The trust store password is the passphrase or key used to encrypt and decrypt the trust store file. This password is required by the eG Agent when it needs to access the trust store file to establish secure connections. Specify the password in Trust Store password text box. database - Specify the name of the database on the monitored DB2 server to be used by this test

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Dynamic SQL Rate:	Indicates the rate of dynamic SQL statements that were attempted on this logical partition.	Statements/sec	This is an indication of throughput of the system during the monitoring period. A high value of dynamic SQLs and low value of failed SQLs indicate good throughput.
Select SQL rate:	Indicates the rate at which SELECT SQL statements were executed on this logical partition during the last measurement period.	Statements/sec	This measure can be used to determine the level of database activity.
UID SQL rate:	Indicates the rate at which update/delete/insert statements were issued on this logical partition during the last measurement period.	Statements/sec	This measure can be used to determine the level of database activity.
Failed SQL Rate:	Indicates the rate at which SQL statements to this logical partition failed.	Statements/sec	A relatively high value indicates a problem. Failed SQL statements waste system resources. Hence, the value of this measure should be very low.
Percent Failed SQL:	Indicates the percentage of SQL statements attempted on this partion that failed during the interval. This value includes all SQL statements that received a negative SQLCODE	Percent
Percent DDL SQL:	Denotes the percentage of SQL statements attempted on this logical partition that were DDL (Data Definition Language) during the last measurement period.	Percent	This value should normally be low.
Percent UID SQL:	Indicates the percentage of update/insert/delete statements executed on this logical partition during the last measurement period.	Percent	This measure can be used to determine the level of database activity.