Run server reports from the Admin Tools window

Use the Admin Tools window to run server reports such as Server Status Report and Cache Manager Statistics.

Server reports available from the Admin Tools window

The following table lists the server reports that you can generate from the Admin Tools window.

Table 9-3. Server reports
Report Name	Description
Broker Connection	Information about open database pool connections, organized by connection ID.
Broker In Use Sessions	Information about database pool connections in use, organized by user. If the server parameter `DB_SESSION_TRACKING` is set to `true`, this report also shows stack traces of where the connection is allocated.
Broker Performance	Statistics on database connection usage in the connection pool, to help assess system performance. For performance reasons, the PPM Server holds a connection pool to the database and reuses these connections for accessing the database. Prepared statements created within a connection are also held open in a cache. If the PPM Server cannot allocate more connections, threads that need to access the database might need to wait for a connection. This report also shows: Number of threads waiting for connections Average duration threads had to wait for connections Percentage of threads that had to wait for connections Total number of connection requests, and if JDBC logging is enabled Statement cache hit rate percentage (over the last 100 statements)
CacheManager Sizes	Displays the number of objects in the cache of each entity, the total cache size (in KB), and the average size of each cached object type.
CacheManager Statistics	Displays useful statistics on the caching behavior of each cacheable entity in OpenText PPM, including: Hits, misses, and hit rate Number of cache flushes (broken down by the categories "old", "idle", "reclaimed", and "max cache size reached") Average load time Cached object count and maximum idle time
Client Font	All supported fonts for the OpenText PPM installation.
Client Property	Details about the environment of the client computer currently running the PPM Workbench.
Client Time Zone	All time zones recognized by the client.
Execution Dispatcher Manager	Batch executions in progress.
Execution Dispatcher Pending Batch	Batches pending execution due to the lack of available execution manager threads.
Execution Dispatcher Pending Group	Batches pending group execution (batches that are grouped together) due to the lack of available Execution Manager threads.
Installed Extensions	Displays the names and versions of Deployment Management Extensions installed (if any).
JVM Memory	Free and total memory in the PPM Server JVM.
Kintana RMI	All RMI connection threads.
Server Cache Status	Shows the following cache information: Cached entities Number of units that can be cached Number of free units The number of hits and misses, and the miss rate Number of entities swapped Amount of memory taken up by the cache Note: Although this report displays information that is similar to the that displayed in the CacheManagerStatistics report, the data is for a different set of cached objects.
Server Configuration	All server parameters in effect for each of the active servers. Includes parameters not specifically set in the `server.conf` file.
Server Event Listener	Event messages that the PPM Server can send to the client.
Server Logon	Information about all users logged on to the PPM Server(s) and logon information such as IP address and idle time. This information is used to determine PPM Server load. If server clustering is used, this report provides a picture of load distribution.
Server Status	Status information about PPM Server(s): Whether the server is available and its start time Length of time the server has been available Number of users logged on to the server Number of users active during the last minute You can also use the Administration Management Console to view the status of PPM Servers. For information about the Administration Management Console, see View server status.
Server Thread	Information about running threads within a PPM Server(s). This information is used to determine which services are running. If a server cluster is used, this report also provides information about which server is running these services.

Run a server report

Follow the steps below to select and run a server report:

Open the Admin Tools window in the workbench. For details, see Access server tools in workbench.
Expand the report list in the Admin Tools window and select a report.
Click Submit.

The Admin Tools window displays the output of the selected report.

Note: If you run a report on a OpenText PPM instance that supports multiple languages, then the resulting report is generated in the language you selected at logon (your session language). Because the report is only generated once, the language used to display the contents does not change, and any user who later views the report sees it in its original language. For information about multilingual support in OpenText PPM, see the Multilingual User Interface Guide.

Run server reports from the command line

You can also run server reports directly from a command line on the PPM Server using the kRunServerAdminReport.sh script, which is located in the <PPM_Home>/bin directory. For more information about the kRunServerAdminReport.sh script, see kRunServerAdminReport.sh.