Symptom
Output of dbcc hotbufs can show dbid=0 - Why?
Patterns seen:
- 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
- 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
- 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.