Solution : https://service.sap.com/sap/support/notes/217538 (SAP Service marketplace login required)
Summary :
When using Transaction DB02 in SAP to analyze database table performance, initial selection of table details causes significantly longer response times than subsequent selections. The root of this problem lies in the system's method of loading all database tables upon the first request, regardless of specific table queries. To mitigate this issue, it's crucial to apply the transport updates mentioned in SAP Note 101217 in the recommended sequence. Additionally, SAP Note 13719 provides specific transport codes for different SAP releases, ensuring compatibility and system optimization. Note restrictions include a maximum of 36 table selections per call, with excess leading to run time errors.
Key words :
additional key words db2, run time error generate_subpool_dir_full, current maintenance level, underlying ebcdic sorting, table detail analysis, long response time, additional table selection, db02 table selection, database performance tables, response time
Related Notes :
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 103707 | DB2/390: Transports for 4.0B |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 13719 | Preliminary transports to customers (note for customers) |