PM_OBJLIST -- Deletion jobs taking huge times

[Former Member]

Hello All,

We are archiving Serial Numbers using the archiving object PM_OBJLIST. We are scheduling the delete jobs manually. The issue is that the Delete jobs are taking huge times (many hours) in execution, and we are scheduling the detele jobs one by one. This activity is taking a lot of time, since there are many such delete jobs to be scheduled.

• Can we schedule the archival Delete jobs in parallel?
• If Yes, How many jobs can be scheduled at a time?

• Is it Archival Object specific, or can be followed for any object?

• Can we schedule WRITE and STORE jobs also in Parallel?

Kindly help me in finding a solution to the above queries.

With Regards,

Soumya

[Former Member · Accepted solution]

Hello All,

If any one has come across such a scenario kindly explain.

Is it a standard practice that we should not schedule the standard archival Delete program in parallel?

I may be following wrong proctice. If someone has done parallel job scheduling, kindly help me.

Regards,

Soumya

[Former Member · Accepted solution]

Hi Soumya,

• You can schedule the deletion program parallelly. As the deletion runs specific to the archive file, the data which deletes from the table also happens at different data blocks.
• The number of jobs is depends on the system resources availability. 
• Write and store would not happen parallelly. Write has to be finish to store the archive file.

Regards,

Sudheer T

[Former Member · Accepted solution]

• Can we schedule the archival Delete jobs in parallel?

--> Yes you can schedule deletion jobs in parallel but remember each deletion job would use one background process.

• If Yes, How many jobs can be scheduled at a time?

--> It depends on how much background process you have in the system and how many do you actually can use for archiving.

• Is it Archival Object specific, or can be followed for any object?

--> Can be followed for any Archiving object its not specific for Archiving objects.

• Can we schedule WRITE and STORE jobs also in Parallel?

--> No, since store job gets created after the write job its the sequence.