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
 

 

Restart Problem when using VSAM restart file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
nabihtrap

New User


Joined: 28 Jul 2009
Posts: 2
Location: chennai

PostPosted: Tue Jul 28, 2009 11:51 am    Post subject: Restart Problem when using VSAM restart file
Reply with quote

Hi All,

I have a program which uses VSAM file as a restart file. The program updates a database (DB2) and has a restart logic using the VSAM file.
It commits after every n records processing the Database and writes the last committed record keys in the VSAM restart file.

Now when job is terminated due to any fatal error like db2 contention or data exceptions the VSAM restart file has the last committed record but if the job fails due to time out or if the job is canceled the VSAM restart file doesn't have the last committed records.

Can you please let me know why this happens?

Thanks
P.s. there is no problem in anyways if the restart file is a PS
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 29, 2009 5:29 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Quote:
Can you please let me know why this happens?
I believe more info would be needed for us to be able to help.

If i understand, the vsam file behaves differently for an s0c7 and a s222?

How often is a commit and the vsam file update done? Is the vsam record repeatedly read and updated? What happens if the vsam file is closed and re-opened between updates? I don't suggest this as a solution, only an experiment.

Why not use the PS restart file?

Why not discontinue recovering and simply restart the job from the beginning after the current abended process is backed out?
Back to top
View user's profile Send private message
nabihtrap

New User


Joined: 28 Jul 2009
Posts: 2
Location: chennai

PostPosted: Thu Jul 30, 2009 9:20 am    Post subject:
Reply with quote

Hi,

Thanks a lot for your response.

Quote:
How often is a commit and the vsam file update done? Is the vsam record repeatedly read and updated? What happens if the vsam file is closed and re-opened between updates? I don't suggest this as a solution, only an experiment.

The commit depends on the commit frequency, currently its 100 records. The VSAM is written every time the frequency reaches 100. The VSAM is not closed and re-opened in between the program is running. That is the reason VSAM file is implemented for restart logic. It reduces the number of file open and close operation.

Quote:
Why not use the PS restart file?

Re-write a PS file is not working for restart. We tried doing a close, read and write every time the commit happens. But that’s too much of file operation, so switched to VSAM. Where using the single key I can write a single record as many times as possible.

Quote:

Why not discontinue recovering and simply restart the job from the beginning after the current abended process is backed out?

The problem is that the job is running over 60 Million data and sometimes, it goes on timeout. If 20 MM records are processed and db2 operation is performed, we don’t want to re- run from beginning.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am


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