IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

LOCKMAX Issue for BMP Jobs


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Gopinath Shanmugam

New User


Joined: 02 Sep 2015
Posts: 3
Location: India

PostPosted: Thu Jul 19, 2018 8:12 pm
Reply with quote

We have converted DLI jobs as BMP and facing LOCKMAX (U3301) issue for them. If we increase the LOCKMAX, we are able to complete the jobs without any issues. But we should follow the standard LOCKMAX value across the application and it must be '5'. Also we could not change the checkpoint logic due to some restrictions in the existing functionality.

See the below example for one of the restriction.

Under the PART-A(input data from file) , If we have 10000 records and checkpoint issued after processing entire PART-A. We will face lockmax issue. To avoid this, If we issue checkpoint for every 1000 records under part A, when job abends at 3000+ record we should remove PART-A from the input ( Since PART-A is the input data from file and 10000 records under that are read from DB in the program ). But already 2000 records are committed due to two checkpoints issued for every 1000 records. At this point we need to rollback the data for those 2000 records and this is not possible. Even ROLB option will help till last checkpoint ( As per my understanding ).

So please suggest us any option which may help us to run the job with huge volume of data without changing LOCKMAX or Checkpoint logics.
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada

PostPosted: Fri Jul 27, 2018 12:22 am
Reply with quote

To recap what you are asking.

1. You want to change the way this program behaves, so that it will take checkpoints frequently enough that it will not exceed LOCKMAX.

2. You want this program to be able to re-synchronize to the correct input record number and database positioning, in the event that it must be restarted after the jobs fails, and after it has taken at least one checkpoint or extended checkpoint.

3. You want these first two new functions to be implemented by making no changes to the application. As it WAS a DLI application, we should assume there was no checkpoint/restart logic in place prior to conversion to BMP and no method to track/re-establish database positioning and input file positioning.

In other words, you want extensive changes to program behavior, without making any program changes.

So your answer is right there...Pray for a Miracle.
Back to top
View user's profile Send private message
Gopinath Shanmugam

New User


Joined: 02 Sep 2015
Posts: 3
Location: India

PostPosted: Fri Jul 27, 2018 2:59 pm
Reply with quote

Thanks a lot Gary for your reply.

As i mentioned earlier , we have some restrictions to change the existing checkpoint logic in our program. But we have a logic to issue checkpoint ( Main checkpoint ) after completing all the records under PARTA. But we could not add any intermediate checkpoint to avoid LOCKMAX issue.Could you please check the below scenario for more details !

PARTA
record 1 - 1000 => Intermediate checkpoint 1
record 1001- 2000 => Intermediate checkpoint 2
record 2001- 3000 => Abends at 2512th record
record 3001 - 3600

Main checkpoint 1

PARTB
record 1 - 1000

Main checkpoint 2


In the above example, Only PARTA,PARTB are taken from input file and all the records under them are retrieved from database through processing. LOCKMAX will occur when we process all the 3600 records under PARTA.
If we issue intermediate checkpoint at record level(per 1000 records ) to avoid LOCKMAX issue , when the record 2512 abends we can not rollback the data level changes which are committed from 1 to 2000 through previous intermediate checkpoints. Because when we face data issue, PARTA itself is removed from the input file and job is restarted.

So program level changes to avoid LOCKMAX is difficult due to this issue and we are looking some other solution to resolve this issue.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Jul 27, 2018 4:20 pm
Reply with quote

3 options:
1 - bite the bullet and amend the program
2 - write a replacement program - probably 2 as you seem to have two phases of program which is not a good design.
3 - abandon all hope
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada

PostPosted: Tue Jul 31, 2018 1:54 am
Reply with quote

BMC Software does have a product called AR/CTL that may help you.
All you need now is a miraculous pot of gold to pay for it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Help in Automating Batch JCL jobs mon... JCL & VSAM 3
No new posts Submit multiple jobs from a library t... JCL & VSAM 14
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
Search our Forums:

Back to Top