Solution : https://service.sap.com/sap/support/notes/1416955 (SAP Service marketplace login required)
Summary :
Activation issues with InfoObjects in SAP environments can occur after modifying navigation attributes, resulting in activation processes that do not complete or end with database errors. Specifically, the attribute SID table (X table) or time-dependent attribute SID table (Y table) may be empty, rendering the InfoObject inactive. The underlying problems include excessively long SQL statement texts and inefficient DB2 optimizer access plans due to large intermediate result sets caused by Cartesian products. Solutions involve configuring the RSADMIN parameter (SPLIT_SX_TABL_THRES), updating DB2 with requisite APARs, adjusting DB2 registry settings (e.g., DB2_EXTENDED_OPTIMIZATION), and possibly increasing the STMTHEAP database parameter.
Key words :
terms db2udb db2luw db6 optimizer activation sql x-table y-table navigation attribute characteristic performance sql0101n sql0101 db2_extended_optimization gy_delay_lookup gy_delay_expand reason, db2_extended_optimization=gy_delay_lookup db2_extended_optimization=gy_delay_expand, time-dependent attribute sid table, attribute sid table, db2_workload=sap db2_extended_optimization=nljoin_keycard, ixor [db2_workload] db2 luw v9, fix pack 9 db2 luw v9, removing navigation attributes, db2 optimizer generates, sap standard setting resolves
Related Notes :
| 1147821 | DB6: Known Errors and available Fixes in DB2 9.5 LUW |
| 977845 | DB6: Known Errors and available Fixes in DB2 9.1 LUW |
| 536223 | Activating master data with navigation attributes |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |