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: 1817
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: 48
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: 7315

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: 48
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 Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 4 Wed Nov 15, 2017 4:27 pm
No new posts Query on IEFBR14 with GDG Ashishpanpaliya JCL & VSAM 3 Tue Nov 07, 2017 8:34 pm
No new posts Query on XMITIP abdulrafi All Other Mainframe Topics 1 Wed Oct 25, 2017 6:54 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm

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