Symptom
The table storage data collector setup via the transaction DBAcockpit - Configuration - Data Collector Framework overview fails with the following error in the CREATE statement
SQL0206N "S.RECLAIMABLE_SPACE" is not valid in the context where it is used.
CREATE VIEW SAPTOOLS.DBH_SNAP_TABLE AS SELECT...
FROM SAPTOOLS.DBH_SNAP_TABLESTO
Another symptom is when setting up the data collectors, the following error is reported.
DBAcockpit - Configuration - Data Collector Framework, Table Storage collector is not scheduled
Configuration tab shows reason Setup Status is (Unable to get definition of view 'SAPTOOLS.DBH_SNAP_TABLE'!)
Read more...
Environment
Db2 LUW IBM
Product
Keywords
DB2ATS, DCF configuration. Tables (storage)" collector. , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview