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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm


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