on 07-17-2012 4:51 PM
Hi All,
We have the table QMEL for quality notification(PM systems).The total entries are 38,70,388 entries.The tabkle is occupying too much of dialog work process during business hours and it does not allow users to login as too much dialog is occupied by this table QMEL for 4 to 7 minutes.Let me know how to remove the unwanted entries in the table QMEL or is there any method to do housekeeping for the table QMEL.
Additionally, due to this QMEL ,lot of time out error occurs.If possible let me know whether archiving can be done for table QMEL.Kindly provide me your valuable inputs as am facing issues because of this table QMEL.
Regards
Bharatram Ramakrishnan
Hi,
This normally happens for archive insceptions tables. For QMEL sap provide a solution to avoid the long running process.
Note 1445346 - Performance problems when reading the table QMEL
Appreciate me if it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Let me know what are the archiving objects to archive data from table QMEL..And how to start archiving and I have searched via google and the Program RQRQAB00 - Archiving of QM Transaction Data, Setting Archiving Flag is used and the
Note 195425 - PM_ORDER,PM_QMEL,SM_QMEL,QM_QMEL: SAP AS connection.
Let me know whether am proceeding in the right path and if any alternative & simplest way to archive the QMEL table , please let me know the valuable inputs
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To me the logical option will be to archive them, as far as I can see theres dedicated archiving objects for QMEL
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.