BPC 10.0 and IBM DB2 BLU

[Former Member]

Hello,

we intend to use BLU acceleration on our SAP BI 7.31 + BPC 10.0.

There is a procedure converting tables to column organized.

Is there any risk?

Kind regards

Radek

[former_member181999]

Hi Radek,

Yeah there is a procedure for convertion tables from Row to Column. More over BLU does this job online, efficently and effectively provided you are version DB2 10.5.

Details:

BLU Acceleration. This new support of column-organized tables is ideal for data warehouse and analytic workloads. To fully take advantage of the power of DB2 10.5 with BLU Acceleration, the ADMIN_MOVE_TABLE stored procedure was enhanced to move data from a row-organized table into a column-organized table online. The new db2convert command was also provided. The db2convert command internally calls the ADMIN_MOVE_TABLE procedure but has a simple interface and is easier to use.

Of course, you can also do the conversion manually. For instance, you can create a column-organized table with the same structure as the row-organized table and use the DB2 LOAD utility to populate the table.

Learn more here:

Convert row-organized tables to column-organized tables in DB2 10.5 with BLU            Acceleration

Blog: What In-Memory Database for SAP BW? A Com... | SAP HANA

Hope this helps-Thank you.