SAP Knowledge Base Article - Preview

1381865 - How To Enable DB2 Dynamic Statement Cache in Universe Designer

Symptom

In the DB2 world the Dynamic Statement Cache stores access path information to data for dynamic SQL when it is executed the first time. In case the same SQL is executed again, the already existing access path may be used. Is there any parameter within BusinessObjects for DB2 which can be set to make use of the Dynamic Statement Cache (KEEPDYNAMIC=Yes)


Read more...

Environment

  • BusinessObjects Enterprise XIR3.1
  • Universe Designer

Product

SAP BusinessObjects Business Intelligence platform all versions

Keywords

KBA , BI-BIP-SL , Semantic Layer , 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.