Improve delete archiving process

[Former Member]

Hi gurus:

I run a delete process of archive files (table S911 object: MC_S911); this process have more than 15000 seconds.

An archive file have 100 MB (max size); the archive files is stored in iSeries 870 application server, and the DB server is Iseries i570.

Exists some metods to improve this process?

The archive files directory (application server) is shared in NFS format with DB server.

Do you have some suggestion for improve this process?

Do you know how SAP system delete data in DB from archive files?

Best regars

Ernesto.

[Former Member]

Hello Ernesto,

The deletion process of data archiving reads the info (business object records) in the archiving files, then requests DBMS to remove the data.

I would run the deletion background job on 570 as it has faster processor and doesn't have to communicate with DB2/400 over network.

Also I would use local root File System on 570 instead NFS.

Check the "commit counter" in Tcode AOBJ, it should not be too small (causing too many commit requests) or too big (causing prolonged commit requests).

Best regards,

Victor