SAP Knowledge Base Article - Preview

2781816 - DBAcockpit reports error 'ADBC SQL Error occured'

Symptom

While navigating "DBAcockpit > Space > SAP System Overview" the following error is reported:

----------------------------------------------------------------------------------------------------------------------------
ADBC SQL Error occurred
[IBM] [CLI Driver] [DB2]  PART_RANGE_ALERT IS NOT VALID IN THE CONTEXT WHERE IT IS USED
----------------------------------------------------------------------------------------------------------------------------

Checking the developer trace  SQLCODE -206 is reported with the offending sql query referencing table DB2QDB02_SCHEMA:

----------------------------------------------------------------------------------------------------------------------------
C *** ERROR => DB2 Call 'SQLExecute' Error: conHdl = 00 SQLCODE = -206 : [IBM][CLI Driver][DB2] PART_RANGE_ALERT IS NOT VALID IN THE CONTEXT WHERE IT IS USED
[dbdb2cli.c 6403]
C {root-id=0200020000551EE98F8A98D40497910E}_{conn-id=00000000000000000000000000000000}_0
C DB2Trc: Select MAX(TS_SIZE_ALERT), MAX(IX_SIZE_ALERT), MAX(NUM_PART_ALERT), MAX(PART_RANGE_ALERT) from DB2QD\
C DB2Trc: B02_SCHEMA where COLDATE = '20190301' AND SCHEMA = 'SAPR3';
----------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

  • IBM DB2 z/OS
  • SAPCL patch #11

Product

SAP NetWeaver Application Server all versions

Keywords

stored procedure data collector , KBA , BC-DB-DB2 , DB2 for z/OS , 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.