Solution : https://service.sap.com/sap/support/notes/1017625 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues in SAP NetWeaver BW, SEM, or SCM related to queries containing SAP BW temporary tables (/BI0/02, /BI0/06, /BI0/0P). The challenge arises because these tables are managed in a pool and cleared post-query, hence db2support data collected afterwards does not reflect their content during the query, rendering the data ineffective for root cause analysis. The solution involves creating and retaining copies of the temporary tables during query execution, managed by a query management table (DB6_BW_TMPTABS_SAVE), with settings adjusted via RSADMIN parameters. For proper versions, specific Support Packages and SAP Notes are recommended for import.
Key words :
terms optimizer access plan temporary tables 06 02 0p 01 0z reason, sapbwnews bw sp20 netweaver'04 stack 20, bw temporary tables continues indefinitely, sap bw temporary tables occurring, debug options dialog box, native db6 sql statement, setting rsadmin parameter db6_bw_tmptabs_save, set rsadmin parameter db6_bw_tmptabs_save, delete rsadmin parameter db6_bw_tmptabs_save, sap netweaver bw system
Related Notes :
| 991093 | SAPBINews NetWeaver 7.0 BI Support Package 13 |
| 986891 | SAPBWNews BW Support Package 20 NetWeaver '04 Stack 20 RIN |