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:
SAP on IBM Db2 for Linux, UNIX, and Windows
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 pageThis 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.