SAP Knowledge Base Article - Preview

3191341 - DB6: SQL0960C The maximum number of objects encountered due to /BI0/01* tables

Symptom

  1. You got the SQL0960C error in SM21 (system log), ST22 (short dump) or db2diag.log.
  2. The tablespace in question is full of /BI0/01* tables

e.g: 
select tbspace, count(*) from syscat.tables group by tbspace

TBSPACE                                                                                                                          2
------------------------------------------------------------------------------------------------- -----------
...
ABC#STABD                                                                                                                     53741
...

select count(*) from syscat.tables where tbspace = 'ABC#STABD' and tabname like '/BI0/01%'

 1
-----------
      47412
 1 record(s) selected.


Read more...

Environment

 SAP on IBM DB2 for Linux, UNIX, and Windows

Keywords

SQL0960C, /BI0/01, SAP_DROP_TMPTABLES, temporary table , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , 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.