Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1610
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: 44
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: 7232

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: 44
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 I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us