
	Home > Ask the Data management / BI Experts > Questions & Answers > Rolling back DB2 tables

Ask The Data Management Expert: Questions & Answers

EMAIL THIS

Rolling back DB2 tables

EXPERT RESPONSE FROM: Tom Ross

		Pose a Question

		Other Data Management Categories

		Meet all Data Management Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 16 September 2004
I have a an online COBOL-CICS-DB2 program where I receive data through commarea from a front end Java application. This program is accessed from CICS Transaction Server using the program name -- no trans id -- by a Java application in WSAD.
The data would be inserted or updated in 10 different DB2 tables using CURSORs. For example if the insert/update using a cursor in the ninth DB2 table has failed.
How do I rollback all the previous tables which have been successfully inserted/updated? In other words, if the program has encountered any sort of error, I want to undo the whole transaction.

Unless I am missing something here in terms of your application design, as long as you do not COMMIT the ROLLBACK issued through the CICS program, it would roll back all of the updates to the beginning of the transaction -- or the last COMMIT/SYNCPOINT).

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	IBM DB2 management
	How to select an MPP database: DB2 vs. Teradata
	What are the top database management systems (DBMS)?
	Are there benefits to using both Teradata and a DB2 database?
	Tips for evaluating top database management systems and choosing a small DBMS
	Exec explains IBM's Information On Demand (IOD) initiative
	IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 7
	IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 6
	IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5
	DB2 basics
	IBM DB2 basics

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy