20 pts.
 AS/400 transactions
If iam in the mid of transaction of some sqlcodes if suddenly server is shut downed due to power down or sumthing what will happen. (Transaction will be committed or Transaction will be rollbacked or status ‘COMMIT PENDING’, or transaction wil stop)

Software/Hardware used:
ASKED: September 9, 2011  12:51 PM
UPDATED: March 31, 2012  4:53 PM

Answer Wiki:
If you have a UPS, process will continue with out interruption. Else, Transaction will not commit, it should rollback on IPL
Last Wiki Answer Submitted:  September 9, 2011  1:43 pm  by  CharlieBrowne   32,785 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,785 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

What is the commitment control environment that you are running in? Different commitment definitions will give different results, for example you might not have one active at all.

Tom

 107,845 pts.