Kontakt

Ansicht
Dokumentation

12407 - Tcode ME52 slow on V5R2

12407 - Tcode ME52 slow on V5R2

General Data in Customer Master   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Tcode ME52 slow on V5R2

Hello everyone,

After we upgraded our production system from V4R5 to V5R2 with lastest CumPack,
DB Fix, HIPER group, and other PTFs in II13337, we noticed that Tcode ME52 got
very slow, and verified that it is slow on our DEV/TST box also.

The SAP support folk found the slow SQL statement against table MARA and MARC,
and directed us to IBM support. The IBM support recommended a few PTFs. Some of
them were so "new" that they were not available for download yesterday.

I am curious how the other folks in this group execute Tcode ME52 on V5R2. The
SQL statemnt is

SELECT
T_00 . "MATNR" , T_01 . "WERKS" , T_01 . "XCHAR" , T_00 . "MTART" ,
T_00 . "MATKL" , T_00 . "MEINS" , T_01 . "TRAME" , T_01 . "UMLMC" ,
T_00 . "LVORM" "LVORM_MARA" , T_01 . "LVORM" "LVORM_MARC"
FROM
R3PRDDATA/"MARA"T_00 , R3PRDDATA/"MARC"T_01
WHERE
( T_01 . "MANDT" = ? AND T_00 . "MATNR" = T_01 . "MATNR" ) AND T_00 .
"MANDT" = ? AND T_00 . "MATNR" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
?....
, ? , ? ) AND T_01 . "WERKS" = ? WITH UR

And the library/SQL package/statement is R3PRDX0000/MARA/IHBHNKBKMOHKEMDO.

SQL4021 Access plan last saved on 12/15/03 at 06:19:58.

SQL4020 Estimated query run time is 11 seconds.

SQL4017 Host variables implemented as reusable ODP.

SQL4007 Query implementation for join position 1 table 2.

SQL4006 All indexes considered for table 2.

SQL4008 Index "MARC+WRK" used for table 2.

SQL4011 Index scan-key row positioning used on table 2.

SQL4007 Query implementation for join position 2 table 1.

SQL4006 All indexes considered for table 1.

SQL4009 Index created for table 1.

SQL4014 1 join column pair(s) are used for this join position.

SQL4015 From-column 1.*HOSTVAR, to-column 1.MATNR, join operator MF, join
predicate 1.
SQL4011 Index scan-key row positioning used on table 1.


Anybody has similar/different experiences with ME52 on V5R2?

Thank you very much,
Victor
SAP Basis Manager
Plastiapk Packaging INC

 Durban Tours - Südafrika Safari

ROGBILLS - Synchronize billing plans   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 2584 Date: 20240418 Time: 082633     sap01-206 ( 3 ms )