Solution : https://service.sap.com/sap/support/notes/1645286 (SAP Service marketplace login required)
Summary :
SAP Note addresses issues with the SAPTOOLS.DBH_WLM_STATS_COLLECT, a data collection procedure in the DBA Cockpit that fails to be created, throwing a SQL0104 a SQL error. This note covers the relevance of IBM DB2 versions (V9.5 FP7 and V9.7 FP4) which involve the updated SYSPROC.WLM_COLLECT_STATS procedure after applying Fixpack updates. Instructions are provided to automatically register this updated procedure by running the db6_update_db script detailed in SAP Note 1365982. If faced with the specified SQL error, users should download and execute the aforementioned script and then re-setup the DBA Cockpit stored procedures.
Key words :
terms dba cockpit saptools dbh_wlm_stats_collect sql0104n reason, sqlstate=42601alternative symptom 2a dedicated check, symptom symptom 1the procedure saptools, dba cockpit setup, db2 procedure sysproc, data collector routine, issue points directly, ibm db2 v9, dba cockpit, wlm_collect_stats procedure
Related Notes :
| 1456402 | DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31 |