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
 
About Restart Logic in VSAM-DB2 Program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Mon May 30, 2005 3:21 pm    Post subject: About Restart Logic in VSAM-DB2 Program
Reply with quote

Hi,

When reading a VSAM file and updating database with information read from file in between if Job Abends how to Restart the Job

I Guess developer would place some logic in Program to handle such scienarios ...need inputs on this.
Back to top
View user's profile Send private message

pbgunasekar

New User


Joined: 28 May 2005
Posts: 26
Location: Chennai

PostPosted: Wed Jun 01, 2005 10:01 am    Post subject: Re: About Restart Logic in VSAM-DB2 Program
Reply with quote

hi sudheer,

i didnt work this please try this....

Create an dummy dataset and insert one dummy record in it ..in ur procedure division read this record and using start key place the point there and move the record to working storage and insert it into table...
Add one counter variable for every 1000 records give one commit before commit please write that last record in that dummy dataset....if u got any error read the last record in that dummy dataset and place that point in that dataset with start key...
please try it if any feedback pls inform me...
waiting guna




sudheer648 wrote:
Hi,

When reading a VSAM file and updating database with information read from file in between if Job Abends how to Restart the Job

I Guess developer would place some logic in Program to handle such scienarios ...need inputs on this.
Back to top
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Wed Jun 01, 2005 10:20 am    Post subject: Re: About Restart Logic in VSAM-DB2 Program
Reply with quote

Hi guna,

Suppose if Job abended before atleast a commit point then how to handle the situation.

I think since commit is not reached the database would be rollback automatically.we need to start all from beginning.

Corrections are invited.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Wed Jun 01, 2005 11:32 am    Post subject:
Reply with quote

Timestamp logic will sove this issue.
Back to top
View user's profile Send private message
ronie305

New User


Joined: 09 May 2005
Posts: 3

PostPosted: Wed Jun 01, 2005 4:47 pm    Post subject: Re: About Restart Logic in VSAM-DB2 Program
Reply with quote

this is a typical commit-restart logic....

have a table maintained holding info as:

pgm name
module name
time stamp
counter

when job abends restart from here... store last position where u had commited for restart position.

in sql u can specify : record > last commit position.
Back to top
View user's profile Send private message
pbgunasekar

New User


Joined: 28 May 2005
Posts: 26
Location: Chennai

PostPosted: Thu Jun 02, 2005 6:26 pm    Post subject: Re: About Restart Logic in VSAM-DB2 Program
Reply with quote

hello
i think this is the way .. my friend is working and told they r having one utility namely RESTART in that they register their program it atomatically restart the program where it got abends... i dont know exactly but he told me like this...pls enquire and give feedback
waiting
guna
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm
No new posts Control-M restart instruction sonaliingle CA Products 2 Tue Nov 28, 2017 5:05 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm

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