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
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.