SAP Note 1156578 - DB6: Slow reporting performance, especially on DataStore

Component : BW DB2 Universal Database - BW Database PlatformsHAN-DB-ENG-BW SAP HANA BW Engine

Solution : https://service.sap.com/sap/support/notes/1156578 (SAP Service marketplace login required)

Key words :
terms db2_reduced_optimization tq table queue no_tq_fact dpf multi-partition hash partitioning db2_workload reason, windows database partitioning feature, default db2 registry settings, datastore object active table, join large master data, datastore object active tables, infocube dimension table <datastore_or_fact_table>, table queue operator, table queue, database partition 0

Related Notes :

1329179DB6: DB2 9.7 Standard Parameter Settings
1293745Add. info.: Upgrade to SAP NetWeaver 7.0 EHP 1 SR1 (ABAP)
1138550DB6: Installing Fix Packs for DB2 V9.5 (Windows)
1138549DB6: Installation of Fix Packs for DB2 V9.5 (UNIX & Linux)
1086130DB6: DB2 9.5 Standard Parameter Settings
899322DB6: DB2 9.1 Standard Parameter Settings
374502DB6: DB2 UDB - BW Performance - Overview of notes