Solution : https://service.sap.com/sap/support/notes/374502 (SAP Service marketplace login required)
Key words :
bw facttables 374087transaction db02 shows missing indexes, 780626new db2 udb v8 fixpak4 database feature, db2 udb v8 fixpak4 database feature, turns green 370093temporary views remain, 852748initial aggregate fill/aggregate activation, rsadmin parameter dbms_max_delete 711912performance improvement, improves sap bw query runtimes, supporting nested loop joins, 1156578specific setting od db2_reduced_optimization, bw 369608statistics traffic light
Related Notes :
| 1156578 | DB6: Slow reporting performance, especially on DataStore |
| 957070 | DB6: Deleting redundant conditions on fact tables |
| 784503 | DB6: Performance problems when compressing data |
| 780104 | DB6: Performance impact of BLOCKSIZE on Aggregate Build |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 756918 | DB6: Setting InfoObject tables to "not volatile" |
| 711912 | DB6: Zero elimination causes deadlocks in the database |
| 708183 | DB6: Compression in InfoCubes with stocks takes a long time |
| 700599 | DB6:Dependency between query performance and InfoCube Layout |
| 688647 | DB6: SAP BW and SAP NetWeaver BI Administration Tasks |
| 688083 | DB6: Improved performance when deleting InfoPackages |
| 651691 | DB6: Statistics for temporary BW tables update |
| 622492 | DB6: DB2 UDB EEE statistics for temporary BW tables |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 546262 | DB6:Administration & Performance on SAP BW, SAP SCM, SAP SEM |
| 523249 | SAPBWNews BW 3.0B Support Package 12 |
| 523248 | SAPBWNews BW 3.0B Support Package 11 |
| 523150 | SAPBWNews BW 2.0B Support Package 31 |
| 414728 | SAPBWNews BW 2.1C Support Package 12 |
| 398155 | SQL911 (Deadlock) in parallel data loads in BW DB6 |
| 374464 | BW 2.0B DB2 UDB EEE Statistics on Z-tables |
| 374087 | DB6: BW 2.0B on DB2 UDB EEE: DBDIFF Handling |
| 370093 | DB6: BW 2.0B: temp. views remain in db catalog |
| 369608 | DB6: Cube Statistics Check does not reflect Views |
| 355191 | DB6: Debugging of BW queries with hierarchies |
| 337723 | BW 2.0B on DB2 UDB: 46D Kernel with BW SP 6+ needed |
| 328985 | DB6: Deadlocks in Catalog Statements; Solution with CTE's |
| 328322 | DB6: DB2 UDB EEE Indexing Scheme of BW Facttables |
| 328106 | DB6: Database statistics for BW Tables on BW 2.0B, BW2.1C |