Symptom
- After upgrading DMIS 2011 (SLT 2.0) Component from SP12 to SP24, In DBACockpit Dashboard,
"Top tables by size" & "Top tables by I/O" show incorrect DB schema <SID>.S24MONDB. The expected schema (owner) should be <SID>.SAPSR3. e.g:
- Note 1619967 - SYB: DBA Cockpit Correction Collection SAP Basis 7.31 is on the latest version.
- In DBACockpit -> DB connection, the DB schema is correct as <SID>.SAPSR3.
- In DBACockpit -> Space->Single Table Analysis, table owner is SAPSR3 which is correct.
- Checking in isql, sp_help show the table owner is SAPSR3 for all of involved tables.
- Checking <SID>..sysobjects, there is no table owned by S24MONDB (uid 5); all the involved tables are owned by SAPSR3(uid 4)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) 7.31
Product
SAP Adaptive Server Enterprise 16.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3
Keywords
Top tables by size, Top tables by I/O, S24MONDB, DBACockpit, DBA Cockpit, schema, owner , KBA , BC-DB-SYB , Business Suite 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.