RSXMB_ARCHIVE_MESSAGES execution time

[Former Member]

Hi,

I have some trouble about the execution time of the program RSXMB_ARCHIVE_MESSAGES. It takes about 5 hours to archive XML

JOBID START TIME END TIME ELAPSED CPU

------------------------------------------------------------------------

18515000 09/12/2013 18:51:00 09/12/2013 23:59:00 05:07:48 00:00:00

20124400 08/12/2013 20:12:00 09/12/2013 01:01:00 04:49:23 00:00:00

18492200 06/12/2013 18:49:00 07/12/2013 00:32:00 05:42:55 00:00:00

19123500 05/12/2013 19:12:00 05/12/2013 23:27:00 04:14:42 00:00:00

18384400 04/12/2013 18:38:00 04/12/2013 23:14:00 04:35:40 00:00:00

19560900 03/12/2013 19:55:00 04/12/2013 00:49:00 04:53:55 00:00:00

18484600 02/12/2013 18:48:00 02/12/2013 23:27:00 04:39:06 00:00:00

05142600 02/12/2013 05:14:00 02/12/2013 16:28:00 11:14:31 00:00:00

18475900 29/11/2013 18:47:00 29/11/2013 22:47:00 04:00:10 00:00:00

18515300 28/11/2013 18:51:00 28/11/2013 23:28:00 04:37:10 00:00:00

18413600 27/11/2013 18:41:00 27/11/2013 22:52:00 04:10:48 00:00:00

18411800 26/11/2013 18:41:00 26/11/2013 23:20:00 04:39:38 00:00:00

18424500 25/11/2013 18:42:00 25/11/2013 22:32:00 03:49:47 00:00:00

04042600 25/11/2013 04:04:00 25/11/2013 09:18:00 05:14:14 00:00:00

19032800 22/11/2013 19:03:00 23/11/2013 00:46:00 05:42:50 00:00:00

19321300 21/11/2013 19:32:00 22/11/2013 01:02:00 05:30:32 00:00:00

18525000 20/11/2013 18:52:00 21/11/2013 00:19:00 05:26:39 00:00:00

19092300 19/11/2013 19:09:00 19/11/2013 23:36:00 04:27:02 00:00:00

Sometimes there is like 60000 XML archived or 700 ...

Date       Time     Message text                                                                               

16.12.2013 18:48:56 Job started                                                                                
16.12.2013 18:48:56 Step 001 started (program RSXMB_ARCHIVE_MESSAGES, variant XXXXXX, user XXXXXXX)
16.12.2013 18:48:56 Value for parameter ARCHIVE-PERSIST_DURATION-ASYNC: '030'                                  
16.12.2013 18:48:56 Value for parameter ARCHIVE-PERSIST_DURATION_UNIT-ASYNC: 'D'                                
16.12.2013 18:48:56 Value for parameter ARCHIVE-ROWS_PER_LOOP: '1.000'                                          
16.12.2013 18:48:56 Value for parameter ARCHIVE-JOB_LOG_LEVEL: '0'                                              
16.12.2013 18:48:57 Archiving session 000201 is being created                                                   
16.12.2013 18:53:28 Path: /int/XXX/001/Arch/BC_XMB/                                                             
16.12.2013 18:53:28 Name for new archive file: XXX001_201312161853280_BC_XMB.adk                                  
16.12.2013 23:07:54 701 XML messages archived                                                                     
16.12.2013 23:07:54 Job finished 

Any people would know how to get a less execution time for this program ?

Thanks.

Kind Regards

[Former Member]

Hi,

I'm still looking for a less execution time for this program.

Anyone ?

Thanks

[Former Member]

Hi Karl,

Usually it should take around 90mins to archive 60K messages.

Try to schedule the job during non peak hrs normally during night.

Limit the size of file created to 20MB refer http://scn.sap.com/docs/DOC-3890 for details.

SAP database response might be slow, check with your BASIS team.

Regards,

Pranav