2633038 - How to monitor Main/Temp cache allocation status -- SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2633038 - How to monitor Main/Temp cache allocation status -- SAP IQ

Symptom

While data modification jobs are running, this error "All buffer cache pages are in use..." happened in Main Cache. Customer wanted to trace main cache usage.

 >> Error

     .. 0000600880 Rbck
     .. 0000601140 Exception Thrown from slib/s_blockmap.cxx:7144, Err# 0, tid 17 origtid 1106
     .. 0000601140 O/S Err#: 0, ErrID: 2097 (s_nobuffersexception); SQLCode: -1009031, SQLState: 'QSA31', Severity: 14
     .. 0000601140 [20052]: main Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache. Current buffer cache is 30000MB.
       -- (slib/s_blockmap.cxx 7144)


Read more...

Environment

  • SAP IQ16.0
  • SAP IQ16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

Insufficient cache, "out of buffer", exhausted, , KBA , BC-SYB-IQ , Sybase IQ , How To

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.