Obtain a List of Available Diagnostic Categories

You can first run OBISAvailableDiagnostics() to get a list and description of the diagnostic categories that are available.

See the following example:

call OBISAvailableDiagnostics()

The results appear similar to the following:

Category	Description
General	General overview of the OBIS instance you are connected to.
DBInstance:DBNAME1	All of the statistics related to the DB instance named in DBNAME1
DBInstance:DBNAMEn	All of the statistics related to the DB instance named in DBNAMEn
LDAP:Instance1	All of the statistics related to the LDAP instance named in Instance1
LDAP:Instancen	All of the statistics related to the LDAP instance named in Instancen
DBConnectionPool:Instance1	All of the statistics related to the DB connection pool named in Instance1
DBConnectionPool:Instancen	All of the statistics related to the DB connection pool named in Instancen
ThreadPool:Instance1	All of the statistics related to the Thread pool named in Instance1
ThreadPool:Instancen	All of the statistics related to the Thread pool named in Instancen
Cache:Instance1	All of the statistics related to the Cache named in Instance1
Cache:Instancen	All of the statistics related to the Cache named in Instancen

All categories, except for the General category, are Instance categories. Instance categories are statistics related to a particular instance object (like a specific physical database). If multiple instances of an object are initialized, separate categories exist for each instance, in the format category_name:instance_name. See the preceding table for examples.

Note the following about the ODBC/JDBC categories:

• The ThreadPool category only displays statistics from threads created and managed by the DbConnection PoolMgr.

• The Cache category displays statistics from the Compiler Cache and the LDAP Internal Cache.