Solution : https://service.sap.com/sap/support/notes/390016 (SAP Service marketplace login required)
Key words :
sap bw system frequently creates db2 indexes, buffer pool tuning db2 buffer pools play, sap profile parameter dbs/db2/use_define_no = 0, sap profile parameter dbs/db2/use_define_no=1, luw whendb2_delete_luw_limit 485878 deleting requestsdb2_hierarchy_nte_limit 732917 max, /servers/eserver/zseries/software/sap/, dsnutils stored procedures sap bw, db2 optimizer executes table scans, parameter note description-----------------------------------------------------------------------db2_rowlock_limit 485878 size, db2 dsnutils stored procedures
Related Notes :
| 1149824 | DB2-z/OS: BI 7.x: DB settings and performance |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 572095 | DB2/390: Improve prepare time |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 536074 | DB2 z/OS: BI: Configuring buffer pools for SAP BI |
| 514907 | Processing complex queries (data mart, and so on) |
| 485878 | DB2/390: BW: Partitioning the PSA tables with Version 7 |
| 192658 | Setting parameters for BW systems |
| 184905 | Collective note Performance BW 2.0 |
| 81737 | DB2-z/OS: APAR List |