SAP Knowledge Base Article - Preview

2896028 - DB6: Slow performance of BW processing with BW temporary tables since conversion to BLU

Symptom

After the conversion to BLU, you notice the performance slowness in BW processing, like query processing or master data load.
From the application snapshot, you see the problematic query is using BW temporary table with row-organized.

Please check SAP Note 1139396-Temporary database objects in BW 7.X for the possible BW temporary tables.

### Case Study ###
During the master data load, the following SQL is causing the performance issue:

UPDATE "/BI0/S<infoobject>" SET "ABC" = ? WHERE "SID" IN ( SELECT "/BI0/0600000123"."SID" FROM "/BI0/0600000123" ) WITH CS

And /BI0/S<infoobject> is column-organized while the temporary BW table /BI0/0600000123 is row-organized.

You can use the following SQL to check if table is column-organized or row-organized:
select varchar(tabname, 35), tableorg, create_time from syscat.tables where tabname like '<table name>';

Check tableorg column:
C=column-organized, R=row-organized


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

DB2 BLU Acceleration, column-organized tables, row-organized temporary tables, DB6_TMP_USE_CDE, /BI0/06, /BI0/0P , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem

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.