MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Hi all,

Suppose if 1 million rows were committed in the database.
How to revoke the changes.
How to delete the records.

Could you pls come up with the solution.

Thanks in advance.
_________________
Satya

kolusu · Posted: Tue May 20, 2008 12:09 pm Post subject:

satyenderd,

Take a quiesce before issuing the commit and if you need to rollback then use the quiesce point and rollback the changes

Kolusu

dbzTHEdinosauer · Posted: Wed May 21, 2008 11:31 am Post subject:

send out your CV's.
_________________
Dick Brenholtz
American living in Varel, Germany

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Kolusu,
Thanks for the info.

But my question is, if I have already committed the records and how to roll back the changes.

Thanks in Advance.
_________________
Satya

Nic Clouston · Posted: Mon May 26, 2008 4:47 am Post subject:

Recover to previous backup - you did take a backup before processing that many records didn't you? If not - send out your CV - or the application designer should.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks all for your suggestions.
_________________
Satya