Hi,
We have scheduled a weekly job SAP_BC_XMB_DELETE_711 with 2 steps: 1.RSXMB_DELETE_MESSAGES and 2.RSXMB_TABLE_SWITCH. This was scheduled twice a week. Few interfaces have been marked for archive. Due to growing issues it was scheduled 4 times in a week, i.e. Tuesday, Thursday, Saturday and Sunday. After this we have found that the job took nearly 24 hrs to complete and now it takes more than 32 hrs.
A huge no. of messages are just being moved everytime,
22.12.2012 01:00:14 Job started
22.12.2012 01:00:14 Step 001 started (program RSXMB_DELETE_MESSAGES, variant &0000000000015, user ID BASIS)
22.12.2012 01:04:47 35,655 XML messages deleted
22.12.2012 01:04:47 Step 002 started (program RSXMB_TABLE_SWITCH, variant &0000000000015, user ID BASIS)
22.12.2012 01:09:57 Messages Moved Until Now: 4,100
22.12.2012 06:19:58 Messages Moved Until Now: 200,244
22.12.2012 16:44:58 Messages Moved Until Now: 656,644
22.12.2012 20:24:56 Messages Moved Until Now: 800,944
23.12.2012 01:59:56 Messages Moved Until Now: 1,002,087
23.12.2012 08:34:58 Messages Moved Until Now: 1,273,287
23.12.2012 08:38:34 Persistence tables reorganized
23.12.2012 08:38:43 @5C@ Recommendation for persistence tables
23.12.2012 08:38:43 Reduce the retention period for XML messages
23.12.2012 08:38:43 Job finished
It was observed that several messages are not in final state. What can be done to delete these message from Integration Engine and Adapter Engine as well to resolve this problem.
Following are some statistics: