Skip to Content
0
Former Member
Dec 24, 2012 at 05:08 AM

Delete messages in different states as table size keeps growing

508 Views

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:

Attachments

table stats1.jpg (102.3 kB)
job.jpg (28.7 kB)
table stats2.jpg (108.7 kB)