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

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

Patterns seen:

1. DBID is 0 for normal objects
   PRINTING HOT BUFFERS for Data Cache :Cache_1 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 :Cache_2 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

SAP Adaptive Server Enterprise (ASE) 16.0

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