MVSFORUMS.com :: View topic - Undo changes without using ROLLBACK.

MVSFORUMS.com Forum Index

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Register

Log in to check your private messages

Undo changes without using ROLLBACK.

printer-friendly view

MVSFORUMS.com Forum Index -> Database

View previous topic :: View next topic

Author

Message

prog_mario
Beginner

Joined: 08 Sep 2007
Posts: 86
Topics: 27

Posted: Mon Sep 10, 2007 12:54 pm Post subject: Undo changes without using ROLLBACK.

Let

Send private message

kolusu
Site Admin

Site Admin

Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

Posted: Mon Sep 10, 2007 1:13 pm Post subject:

prog_mario, Are you performing the updates programatically ? If so issue a commit after the 4th update and issue a rollback after the 5th update Kolusu _________________ Kolusu www.linkedin.com/in/kolusu

Send private message

Send e-mail

Visit poster's website

videlord
Beginner

Joined: 09 Dec 2004
Posts: 147
Topics: 19

Posted: Mon Sep 10, 2007 1:20 pm Post subject:

If there is a quiesce point before the last change, you can recover to that point.

Send private message

prog_mario
Beginner

Joined: 08 Sep 2007
Posts: 86
Topics: 27

Posted: Mon Sep 10, 2007 9:09 pm Post subject:

I

Send private message

CraigG
Intermediate

Joined: 02 May 2007
Posts: 202
Topics: 0
Location: Viginia, USA

Posted: Mon Sep 10, 2007 9:34 pm Post subject:

Reply with quote

prog_mario wrote:

I

Send private message

acevedo
Beginner

Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe

Posted: Tue Sep 11, 2007 4:27 am Post subject:

Reply with quote

CraigG wrote:

Keep track of any changes you have made and undo them yourself or forget this silly idea and use what the system offers (commit and rollback).

the best advice you'll get.

Send private message

jsharon1248
Intermediate

Joined: 08 Aug 2007
Posts: 291
Topics: 2
Location: Chicago

Posted: Tue Sep 11, 2007 9:30 am Post subject:

prog_mario I have 3 words for you: Logical Unit of Work. (ok, technically that's 4 words, but there are only 3 that matter) Define that, and the rest takes care of itself.

Send private message

prog_mario
Beginner

Joined: 08 Sep 2007
Posts: 86
Topics: 27

Posted: Tue Sep 11, 2007 12:24 pm Post subject:

Hi. I'm not an advanced programmer on DB2. Maybe my question's not an interest one but in an interview for a job the interviewer asked me that. So I was wondering how could it be... Anyway, thanks a lot everybody. _________________ The more I learn, the more I want to learn.

Send private message

jsharon1248
Intermediate

Joined: 08 Aug 2007
Posts: 291
Topics: 2
Location: Chicago

Posted: Tue Sep 11, 2007 1:24 pm Post subject:

Your interviewer was probably looking for you to answer with SAVEPOINTs. I haven't had an opportunity to use this, but it looks like you could put together a process to do what your original post mentioned. I guess the application could tolerate certain failures as long as some updates were rolled back, and still be considered a complete LUW.

Send private message

prog_mario
Beginner

Joined: 08 Sep 2007
Posts: 86
Topics: 27

Posted: Wed Sep 12, 2007 10:36 am Post subject:

Thank you very much jsharon1248. I found some notes about SAVEPOINT in a tutorial. I _________________ The more I learn, the more I want to learn.

Send private message

jsharon1248
Intermediate

Joined: 08 Aug 2007
Posts: 291
Topics: 2
Location: Chicago

Posted: Wed Sep 12, 2007 11:26 am Post subject:

You're still using a ROLLBACK to undo the changes, but I'm betting that this was what your interviewer was looking for.

Send private message

Display posts from previous:

	MVSFORUMS.com Forum Index -> Database	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group