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.