Not answering your question quite yet, but if “… lock
escalation is not allowed inside the organization” WHY have
they set an escalation limit so low that you can hit it!
If the lock escalation was set higher, your problems may be
Principal Enablement Manager
[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami
+44 1189 218 000
+44 7808 643 479
[login to unmask email]
E2, Eskdale Road
From: Emily Zhang [mailto:[login to unmask email]
Sent: 26 April 2019 16:00
To: [login to unmask email]
Subject: [EXTERNAL] [IDUGEMEA] - Emily question: Can anyone give a
sugguestion on how to purge the chidren and in the same time update
the parents in large amount without backlog?
We have a situation needs to be solved as soon as possible:
Currently we use reorg discard to purge the children tables and
update the status of the parent table after purging. Because the
lock escalation is not allowed inside the organization, we can only
purge the children 1000 a time in a limited time window each day.
Since all the children will update the same parent, we can't run
the job parallel. So there are millions of records needs to be
processed each year and the current strategy caused millions of
records not be able to purged on time.
Basically the current process like this:
1) One job at a time, inside each job, select the primary key of
the 1000 records ( lock escalation limit) to be delete by joining
the parent and the one child by some condition;
3) reorg discard those records from the child;
4) update the status of those records in the parent;
5)run another job till all jobs finish or till the time windows is
due for that day;
Please anybody with more experience to give us some idea about
whether we can improve the process?
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road,
Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered
in England No. 1927903 The content of this email is confidential.
If you are not the addressee, you may not distribute, copy or
disclose any part of it. If you receive this message in error,
please delete this from your system and notify the sender