Solution : https://service.sap.com/sap/support/notes/411798 (SAP Service marketplace login required)
Summary :
The EXPLAIN function in SQL, which assesses access paths for DB2 in SAP environments, malfunctions when set for any similarity degree. To resolve, follow instructions in SAP Note 101217 to import essential transports into your R/3 Release, regularly checking for updates. Additionally, use specific patches for Releases 4.6D and 4.6C detailed in Notes 406744 and 413885, respectively. This will enable the proper functioning of the EXPLAIN function across various DB2 similarity levels in SAP BW and APO systems, but resets the level to '1' unless set globally to 'ANY'.
Key words :
additional key words db2 mvs os390 explain parallelism degree st05, set current degree = ', sql statement prevents, determining access paths, prerequisites - solution make, individual sql statement, latest maintenance level, explain function, explain-function, generally set
Related Notes :
| 535337 | DB2/390: Enhanced SQL EXPLAIN functions |
| 406744 | DB2/390: Error in STU3 function module after PM deactivation |
| 324739 | DB2 z/OS: CCMS transport for 4.6D |
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 13719 | Preliminary transports to customers (note for customers) |