| View previous topic :: View next topic |
| Author |
Message |
kalidasv
Beginner
Joined: 05 Mar 2009
Posts: 13
Topics: 8
|
 Posted: Wed May 20, 2009 3:42 pm Post subject: Checkpoint / Restart in DB2 UDB |
 |
|
Hello all,
In our shop, we use IMS to implement the Checkpoint / restart logic with COBOL & DB2.
I would like to know whether DB2 UDB has any features to support Checkpoint / restart without IMS.
I searched this forum and found many posts related to Checkpoint/restart but could not find any post specific to DB2 UDB. The project I am going to work has DB2 UDB and Informatica.
Thanks in advance.
Kalidas |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12380
Topics: 75
Location: San Jose
|
| Posted: Wed May 20, 2009 4:51 pm Post subject: |
|
|
kalidasv,
Read upon Unit of work. COMMIT. ROLLBACK
Kolusu |
|
| Back to top |
|
|
haatvedt
Beginner
Joined: 14 Nov 2003
Posts: 66
Topics: 0
Location: St Cloud, Minnesota USA
|
| Posted: Sat May 30, 2009 1:04 am Post subject: |
|
|
I suspect that one feature that is missing in DB2 is the ability to handle sequential files, specifically output files. This DB2 does NOT do. There are vendor packages which handle this situation.
output files are a challenge to handle in restart processing.
Chuck H.
_________________
Chuck Haatvedt
email --> clastnameatcharterdotnet
(replace lastname, at, dot with appropriate
characters) |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Sat May 30, 2009 3:03 pm Post subject: |
|
|
| Quote: | | output files are a challenge to handle in restart processing |
not if you output to db2 tables during your processing.
after the program is complete have a dump with sql to generate print files
or the basic sequential file
(if you have to have a sequential file. - tranfer to another computer, restart logic being added to old pgms, etc.)
otherwise, leave it in the db unless it is a print file.
get rid of sequential files if it is new development.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
