IBM Support

APM 8.1.x: DB2 databases

Technical Blog Post


APM 8.1.x: DB2 databases


This blog entry is to explain what are the APM databases and what is their usage.

There are 3 main databases which are installed into the DB2 server:

WAREHOUS database (which is also called the prefetch database) contains resource monitoring metric data from the agents.
The resource monitoring agent dashboard pages display data from this database.
The database also contains the metric data for the Monitoring Agent for WebSphere® Applications Reports for Tivoli Common Reporting.

DATAMART database contains transaction tracking metric data that is displayed in a subset of the transaction tracking dashboard pages for the Response Time agent.
The database also contains the aggregated data that is displayed in the Response Time Monitoring Agent Reports and Monitoring Agent for Synthetic Playback Reports for Tivoli Common Reporting.

SCR32 database contains resource representations of the computer systems, software servers, and server access points that are being monitored by the APM monitoring agents.
Those resource representations are used internally within APM.
The SCR32 database also contains the list of monitoring agents that are connected to the APM server and the list of resource groups and their members.


The MongoDB stores data for the transaction tracking feature that is available with the IBM® Application Performance Management offering, and threshold event data.



Tutorials Point


Subscribe and follow us for all the latest information directly on your social feeds:











Check out all our other posts and updates:

Academy Blogs:
Academy Videos:
Academy Google+:
Academy Twitter :



[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]