Solution : https://service.sap.com/sap/support/notes/1315198 (SAP Service marketplace login required)
Summary :
SAP Note describes an issue where Database Analyzer logs continuous entries indicating a user task processing the same command for prolonged periods. This is often seen with "vsleep" status and corresponds to a DBM server process. Additionally, warnings about file directory entries not updating unless the database is restarted, and counters for sysupdatecounterwanted or index file directories not decreasing or updating post-upgrade. Introduced in version 7.6, these issues typically occur due to DBM server auto-refresh hindrance or lack of updates from terminated tasks. Solutions include deactivating Database Analyzer temporarily, ending database studio connections, and executing specific DBM commands to refresh counters.
Key words :
db_execute check table <table_name>, set file directory counter, internal file size information, older database analyzer versions, db_execute check table, file directory counter, file directory counters, terms file directory, improved file directory, db_cons show tasks
Related Notes :
| 1335585 | |
| 1316540 | |
| 1229738 | Parallel update statistics as of MaxDB 7.6.05 or 7.7.04 |