Symptom
- XI/PI system is using a JDBC adapter to connect to a DB2 database.
- Slow database operations have been identified when PI uses this channel.
- For example a slow SELECT on a DB2 table.
- When running the same select statement directly on the IBM DB2 database, the same operation is efficient.
- Via detailed JDBC adapter trace, the following trace is visible:
Meta data retrieval through getColumns failed for table db2.<TableName>: No results returned. Falling back to old implementation.
Read more...
Environment
-
PI Release Independent
-
SAP NetWeaver
-
SAP Process Integration
Product
SAP NetWeaver all versions ; SAP Process Integration all versions
Keywords
bind variables, metadata, case sensitive, Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, NetWeaver, XI, , KBA , BC-XI-CON-JDB , JDBC Adapter , 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