Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
LOCKMAX Issue for BMP Jobs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: LOCKMAX Issue for BMP Jobs
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: 59
Location: Victoria, BC, Canada

PostPosted: Fri Jul 27, 2018 12:22 am    Post subject: Reply to: LOCKMAX Issue for BMP Jobs
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    Post subject: Reply to: LOCKMAX Issue for BMP Jobs
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: 2122
Location: UK

PostPosted: Fri Jul 27, 2018 4:20 pm    Post subject: Reply to: LOCKMAX Issue for BMP Jobs
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: 59
Location: Victoria, BC, Canada

PostPosted: Tue Jul 31, 2018 1:54 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Introducing new step in set of jobs ravikumar15 CLIST & REXX 6 Wed Oct 17, 2018 2:22 am
No new posts Facing issue while executing multi ro... aagarwal88 DB2 6 Tue Oct 02, 2018 8:11 am
No new posts S0C4-X'11' issue - page translation e... ashek15 JCL & VSAM 8 Wed Aug 15, 2018 4:23 am
No new posts Issue While Recovering a Tablespace satish.ms10 DB2 4 Tue Aug 07, 2018 2:54 am
No new posts Facing Issue in Table Reorg satish.ms10 DB2 1 Tue Aug 07, 2018 2:44 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us