SAP Knowledge Base Article - Preview

2957818 - dbid=0 in output from dbcc hotbufs - SAP ASE

Symptom

Output of dbcc hotbufs can show dbid=0 - Why?

Patterns seen:

  1. DBID is 0 for normal objects
    PRINTING HOT BUFFERS for Data Cache :LoadDB_Cache in Descending Order at the Cache Level.
    1. pageno=8071944 dbid=0 ptnid=1056779126 indid=5 version=1 cache_spin=24253 buf_spin=125
    2. pageno=8383193 dbid=0 ptnid=1056779126 indid=5 version=1 cache_spin=20125 buf_spin=0
     
  2. DBID is 0 for one row and populated for another on the identical dbid/ptnid/indid/page combo
    PRINTING HOT BUFFERS for Data Cache :ETS_AccountDB_Cache in Descending Order at the Cache Level.
    1. pageno=16926947 dbid=0 ptnid=1006623598 indid=2 version=1 cache_spin=136880 buf_spin=0
    2. pageno=16926947 dbid=10 ptnid=1006623598 indid=2 objname=Account_PK version=1 cache_spin=133028 buf_spin=0
    3. pageno=16439752 dbid=0 ptnid=1006623598 indid=2 version=1 cache_spin=129329 buf_spin=0
    4. pageno=16439752 dbid=10 ptnid=1006623598 indid=2 objname=_Account_PK version=1 cache_spin=113372 buf_spin=0
     
  3. worktables, tempdb syslogs and Allocation Page (99)
    PRINTING HOT BUFFERS for Data Cache :tempdb3_cache in Descending Order at the Cache Level.
    1. pageno=716642 dbid=0 ptnid=-411435009 indid=0 version=1 cache_spin=107 buf_spin=0
    2. pageno=716653 dbid=0 ptnid=-411435009 indid=0 version=1 cache_spin=83 buf_spin=0

    PRINTING HOT BUFFERS for Data Cache :MY_LogCache in Descending Order at the Cache Level.
    1. pageno=860276 dbid=0 ptnid=8 indid=0 version=1 cache_spin=38026 buf_spin=0
    2. pageno=876874 dbid=0 ptnid=8 indid=0 version=1 cache_spin=4132 buf_spin=0

    PRINTING HOT BUFFERS for Data Cache :MYDB_Cache in Descending Order at the Cache Level.
    1. pageno=1310976 dbid=0 ptnid=99 indid=0 version=1 cache_spin=92470 buf_spin=0
    2. pageno=25558784 dbid=0 ptnid=99 indid=0 version=1 cache_spin=82405 buf_spin=0


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.