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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.