SAP Knowledge Base Article - Preview

2651760 - SQL0101N : DBSQL_SQL_ERROR

Symptom

  • St22 dump shows
    ===================
    Category Installation Errors
    Runtime Errors DBSQL_SQL_ERROR
    Except. CX_SY_OPEN_SQL_DB

  • Work process shows below error
    =======================
    C *** ERROR in prepareStatement[/bas/749_REL/src/dbs/db6/dbdb6.c, 14321] CON = 0 (BEGIN)
    C &+ DbSlBegReadDB6( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/AIX64] SQL0101N The statement was not processed becau
    C &+ se a limit such as a memory limit, an SQL limit, or a database limit was reached. SQLSTATE=54001
    C &+
    C &+ WITH /* Query with 3581 FEMSes, 120 TERMs, 72 HIERs, 3 GROUPBYs on ZZF_BCS1 */ "T_VIEW_0001P" AS ( SELECT DIS


Read more...

Environment

  • Db2 LUW 10.5
  • SAP NETWEAVER 7.5 / 750

Product

SAP NetWeaver 7.4

Keywords

SELECT, Slow execution of query, Long runtime, PCKCACHESZ, STMTHEAP , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.