Symptom
- ATM seems to be configured correctly without errors, however checking the ATM log and the "Last Evaluation Time", they all shows no recent update for statistics or reorg rebuild.
- There are huge old pending jobs in ATM queue which contains incorrect commands for update index statistics.
Incomplete command in ATM QUEUE, for example:Msg 156: Incorrect syntax near the keyword 'using'.
update index statistics *** using values with consumers = , sampling = percent
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.