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
 

 

Updating the db2 records

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

New User


Joined: 22 Feb 2006
Posts: 2

PostPosted: Mon May 29, 2006 5:24 pm    Post subject: Updating the db2 records
Reply with quote

Hi all!

one of my job doing update the database, the total record is 3500, the job got abend after updating some of the records, how to restart to update the record, which got updated last, any log is there?pleas let me clear my doubt

Thanks
Ramya
Back to top
View user's profile Send private message

Gurmeet

New User


Joined: 22 Feb 2006
Posts: 46
Location: Pune

PostPosted: Tue May 30, 2006 4:42 pm    Post subject:
Reply with quote

Ramya,

Lets take following cases,

1. If you are trying to update all the 3500 records in one update query, then you cannot restart the job i.e. the updates happened before abend would be rolled back and you need to run the query again from the beginning.

2. If there are multiple queries then you need to fire commit statement after each update query to make the updates permanent. In this case you can restart you job from the query which abended.

Hope this clarifies your doubt.

Regards,
~Gurmeet
Back to top
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Tue May 30, 2006 7:34 pm    Post subject: Re: Updating the db2 records
Reply with quote

please search in the forum regarding restart of cobol-db2 program.
iu iwll get the necessary info.
Back to top
View user's profile Send private message
d?b?2-fr

New User


Joined: 31 May 2006
Posts: 1

PostPosted: Wed May 31, 2006 3:19 am    Post subject: Re: Updating the db2 records
Reply with quote

Hello Ramya,

as Gurmeet said, DB2 always lets the data in a consistency state, depending on how your application is written.
Is there a program or a simple SQL request running ?
Are there explicit COMMIT Sql statements ?
What was the SQL return code ?
Did your unit of work update any dataset during the same time ?
....

Many questions to answer to, before deciding to rerun the job or not .

Good luck.
Back to top
View user's profile Send private message
VITTAL

New User


Joined: 13 Mar 2006
Posts: 1

PostPosted: Wed May 31, 2006 10:19 pm    Post subject: CONVERSION OF CHARACTER FORMAT INTO DATE FORMAT IN DB2
Reply with quote

PL EXPLAIN HOW I NEED TO CONVERT CHARACTER FORMAT INTO DATE FORMAT IN DB2
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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am


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