topic Re: Data Locking in Application Development and Automation Discussions

Data Locking

Former Member — Fri, 27 Mar 2009 01:28:54 GMT

Dear all,

I have a Z program that performing ZTABLE delete and update. The execution of the program is being scheduled every night, and multiple jobs need to be created for the same program due to different job need to update/delete different company code data into ZTABLE. Like below:

Job 1, Company code = A100, A200, A300, A400

Job 2, Company code = B100, B200, B300, B400

Job 3, Company code = C100, C200, C300, C400

Since jobs are execute at the same timing, so i need to implement locking on ZTABLE.

Im thinking to lock ZTABLE at record level. Means During Job1's execution, i will lock data for company code A100, A200, A300 and A400. Once lock obtained, then program will proceed to delete company A* data and then follow by update company A* back to ZTABLE with latest data.

On the other side, same program for Job 2 is executing at the same time. This time program is locking data for company B100, B200, B300 and B400. And then program will delete and update ZTABLE dealing with company B* data only.

I might need your advice with the above design if it is workable. Please comment.

Re: Data Locking

Former Member — Fri, 27 Mar 2009 02:13:18 GMT

Why don't you create lock object for you ZTABLE via SE11 ?

Then use function ENQUEUE_ZTABLE (with exclusive lock option) to lock and DEQUEUE_ZTABLE to unlock.

Thanks and regards,

Thanagit

Re: Data Locking

Former Member — Fri, 27 Mar 2009 02:44:24 GMT

Yes, im using the ENQUEUE FM to achieve my locking purpose.

I need advice if my design is acceptable.

Re: Data Locking

Former Member — Fri, 27 Mar 2009 03:42:56 GMT

Hi,

Yes it would work, and its a good approach too which will save lots of time

Regards,

Siddarth

Re: Data Locking

Former Member — Fri, 27 Mar 2009 04:24:43 GMT

Yes. Your approach holds good.

Use Commit statement to update the records and Enqueue/Dequeue statements to lock and unlock.

For more information use F1 or search SDN forums.

Hope this is helpful

Thanks,

Babu Kilari

Re: Data Locking

Former Member — Fri, 27 Mar 2009 06:22:05 GMT

No explanation why 'Yes'.

How come you believe ?

good luck