SAP Knowledge Base Article - Preview

3353798 - DBACockpit Dashboard shows incorrect DB schema(owner) S24MONDB instead of SAPSR3 - SAP ASE for Business Suite

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.