on 10-23-2009 8:23 AM
Hello Experts,
We are experiencing an issue here where SXMB_MONI is taking a long time to populate with, for ex : " Successfully Processed " messages. Even if we choose the execution for only 1 day, it takes more than 12 mins to populate.
What we have observed is that in SM50, the DIA WP is going through a "Sequential Read" of "SXMSPMAST" table.
What we have done so far :
- Updated the DB statistics
- Re-organized the DB
- Applied Notes as per " " and also followed the instructions as suggested.
- Updated the DB parameters ( spfile ) for tuning its performance
- Checked and deleted all msgs in SMQ1 & SMQ2
- Checked for the indices
- Re- created all missing statistics for the DB
My system :
OS : Windows Server 2003 Enterprise Edition, 64 bit
DB : Oracle 10.2.0.4
SAP : PI 7.1
Kernel Release : 710, level 80
Support Packs : SAPKB71004
Could someone assist me with a possible solution as this is very critical for me now ? I am new to XI & PI. Any suggestions with instructions would be of great help.
Thanks in advance.
Edited by: The Fuhrer on Oct 23, 2009 9:24 AM
I resolve this issue with table statistics:
brconnect -u / -c -f stats -t SXMSPMAST2 -f collect,allsel,keep,locked
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fuhrer,
Pls check T Code SM50....some archiving or deletion job is running in Background Dialogue processes on table SXMSPMAST and other data tables.....Then check that your table switch procedure is working or not...
Also do a persistence layer analysis (SXMB_MONI --> Persistence Layer).
If the fill level is over approx 200000 messages (in persistence layer analysis) then you can assume that switch/deletion procedures are not working properly. SXMB_MONI will hang if fill level goes beyond 200000..
Also kindly go through Timeouts from page no 36 in the following link:
Regds,
Pinangshuk.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fuhrer,
Same issue has been discussed in the thread -
Also have a look at these links. it would be helpful -
Regards,
Sunil Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.