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
 
Query about IMS extended checkpoint use in program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
sivasaras

New User


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

PostPosted: Mon Sep 08, 2014 7:59 pm    Post subject: Query about IMS extended checkpoint use in program
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

Senior Member


Joined: 21 Sep 2010
Posts: 1940
Location: NY,USA

PostPosted: Tue Sep 09, 2014 4:28 am    Post subject:
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: 55
Location: Victoria, BC, Canada

PostPosted: Tue Sep 09, 2014 5:01 am    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Sep 09, 2014 12:58 pm    Post subject: Reply to: Query about IMS extended checkpoint use in program
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: 90
Location: chenna/i-

PostPosted: Tue Sep 09, 2014 4:57 pm    Post subject:
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: 55
Location: Victoria, BC, Canada

PostPosted: Tue Sep 09, 2014 11:40 pm    Post subject:
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    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 Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts Query for fetching matching data in t... Poha Eater DB2 10 Mon Jul 09, 2018 6:06 pm
No new posts In which program the FILE CONTROL wil... Poha Eater COBOL Programming 2 Thu Jun 28, 2018 9:02 pm
No new posts Varying List Select SQL Query In DB2 ... NikhilGuptaGaya DB2 5 Wed Jun 27, 2018 11:01 pm
This topic is locked: you cannot edit posts or make replies. Need help - DB2 Dynamic SQL Program e... NikhilGuptaGaya DB2 6 Sat Jun 23, 2018 1:58 pm

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