Solution : https://service.sap.com/sap/support/notes/921164 (SAP Service marketplace login required)
Summary :
Transaction MB51 and the corresponding RM07DOCS report experience prolonged runtimes, sometimes leading to TIME_OUT errors when accessing MM documents. A SQL trace determined suboptimal database optimizer selections. This issue stems from heavy MM document volumes and generalized database interactions that disregard specific database configurations. A solution entails integrating database-specific hints, enhancing SELECT commands involving MKPF and MSEG tables to guide the database optimizer effectively. Detailed instructions and adaptations are provided for DB2, DB6, Informix, MaxDB, MSSQL, and ORACLE systems. Where mentioned databases do not apply, previous access methods persist, potentially warranting future adjustments.
Key words :
component mm-im-gf-perf, runtime 092 database determines optimum access 093 access, system issues warning message m7895, mm-im reporting report rm07docs transaction, match selections source code correctionscorrect, symbol text 091 determine database access, system issues message db634, database determines optimum access, runtime error time_out occurs, added break-point commands
Related Notes :
| 1078584 | MMBE: Performance when calling the material document list |
| 918991 | MB51: Improvements/additions Note 902675/4.70 |
| 902675 | MB51: Database hints to improve runtime / 4.70 |
| 902042 | DBSL: Hint and profile parameter for "substitute literals" |
| 855943 | ORA-01756: "quoted string not properly terminated" |
| 609921 | MB51: Materials not transferred from search help |