SAP Knowledge Base Article - Preview

2799324 - ADBC SQL Error occurred - PART_RANGE_ALERT IS NOT VALID

Symptom

From within DBAcockpit you navigate to 'Space > SAP system overview > Details' and the following error is reported back:

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

The developer trace shows the full query with Db2 SQLCODE -206 reported:

LINE.jpg
C Fri Mar 1 13:21:22 2019
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';
B ***LOG BY2=> sql error -206 performing OPC [dbds 398]
B ***LOG BY0=> [IBM][CLI Driver][DB2] PART_RANGE_ALERT IS NOT VALID IN THE CONTEXT WHERE IT IS USED [dbds 398]
B ***LOG BY1=> sql error -206 [dbacds 1843]
LINE.jpg


Read more...

Environment

  • Db2 z/OS
  • Netweaver AS ABAP
  • SAPCL patch#11 or earlier

Product

SAP NetWeaver Application Server for ABAP for SAP Business Suite all versions

Keywords

SQL0206N kernel collector , KBA , BC-DB-DB2 , DB2 for z/OS , BC-DB-DB2-SYS , DB2 for z/OS - Database interface , 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.