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.
SAP Knowledge Base Article - Preview