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

Query about IMS extended checkpoint use in program


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

New User


Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-

PostPosted: Mon Sep 08, 2014 7:59 pm
Reply with quote

Hi,

I have a db2 batch program which will link to IMS program.

Today we received nearly 840k records, job went late and completed 2 hrs late.

normally job ran within 20 to 30 minutes daily around 3 to 3.30.

when i saw it takes checkpoint correctly when it starts 3.05 am, then it didnt take for sometime, then 3.68 am it takes then stopped and then from 5.08 am it takes and completed .

Please guide me what i need to change in my program to make my program works fine so that next time it wont happen.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2591
Location: NYC,USA

PostPosted: Tue Sep 09, 2014 4:28 am
Reply with quote

This could have happened because before two commits to DB2 whatever rows fetched are in process of IMS DB and hence you could not see the check point and during this window it could have been busy working with IMS DB (with ??? reason it took longer time ). So you basically needs to investigate what was happening between 3.05am till 3.68 am and then till 5.08 am? Check the IMS logs .

Sometimes it is scary like a Paranormal Activity... icon_smile.gif
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 Sep 09, 2014 5:01 am
Reply with quote

So, a DB2 batch program which links to IMS.

Do you mean a BMP batch job executing PGM=DFSRRC00,PARM='BMP,....' ?

You say you "received nearly 840k records".
Do you mean that todays input file contained 840k records?
Is this an unusually high number of input records?
Naturally, more input records would take longer to process.

Or did your program produce 840k output records?
Were they dump records?
Report records?
Something else?

Checkpoint frequency is extremely variable and certainly depends upon how you coded your program.
Did you see any messages indicating that your job was waiting for tape mounts?
Do you checkpoint based upon input record count? Database roots processed? Clock time?

Have you consulted your IMS sysprog to determine if your job was in lock contention with some other job? Do your IMS SLDS reveal an unusually high number of DLI calls from your job during the time there were no checkpoints? How does Workload Manager treat your job...is it getting enough service?

If you have some expectation that anyone here could help you, a complete listing of the job log, JCL and sysmsgs plus some sample output and your program source code would help a great deal.

As it stands now, there are very few clues at the crime scene.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Tue Sep 09, 2014 12:58 pm
Reply with quote

3.68am? Well, there's your error, right there. Clock's broken.
Back to top
View user's profile Send private message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-

PostPosted: Tue Sep 09, 2014 4:57 pm
Reply with quote

yes i am using DFSRRC00, PARM=BMP, yes my job output program produces 840k records

DBA told to change checkpoint logic

but stil i am unclear on that
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 Sep 09, 2014 11:40 pm
Reply with quote

Sadly, with the information provided, we cannot help you. icon_cry.gif
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 How to Parameterize Eazytrive program All Other Mainframe Topics 1
No new posts linking an ALC program to a Relationa... PL/I & Assembler 1
No new posts Need Help with on of the coalesce query DB2 4
This topic is locked: you cannot edit posts or make replies. Passing a field name to COBOL program COBOL Programming 10
This topic is locked: you cannot edit posts or make replies. Sample CICS Webservices Program CICS 1
Search our Forums:

Back to Top