SAP Note 1111597 - DB6: SAPTOOLS tablespace

Component : CCMS/Database Monitors for DB2 Universal Database - DB2 Universal Database for Unix / NT

Solution : https://service.sap.com/sap/support/notes/1111597 (SAP Service marketplace login required)

Summary :
Starting with Enhancement Package 1 for SAP NetWeaver 7.0 and 7.10, a new tablespace, SAPTOOLS, has been required for databases using DB2 V9.5 or higher to enable historical monitoring of database performance via the DBA Cockpit, transferring data to SAP Solution Manager BW. Users missing this tablespace are directed to create it. It's automatically generated if DB2's automatic storage management is enabled; otherwise, it must be manually created through the DBACOCKPIT transaction by accessing the "Space -> Tablespaces" menu and using the "Add" option. Enabling AUTORESIZE on the DMS tablespace is recommended.

Key words :
dba cockpit dumps performance data, db2s automatic storage management, provide historic performance monitoring, dba cockpit automatically creates, sap solution manager bw, create tablespace saptools manually, sap solution manager system, solution manager diagnostics, sap solution manager, dba cockpit locally

Related Notes :

1630506DB6: History management of monitoring data
1109514DB6: SAPEVENTMON tablespace and database partition group