DB2 Transaction - Programmer and Software Interview Questions and Answers

How do transactions work in DB2? How does DB2 support transactions?

In DB2 UDB, all transactions are implicit by default, just like Oracle. Here are the SQL statements that are used when supporting transactions in DB2:

COMMIT
SAVEPOINT
RELEASE
ROLLBACK

Hiring? Job Hunting? Post a JOB or your RESUME on our JOB BOARD >>

Subscribe to our newsletter for more free interview questions.

Follow @programmerintvw

Leave a Reply Cancel reply

Would you like to thank ProgrammerInterview.com for being a helpful free resource? Then why not tell a friend about us, or simply add a link to this page from your webpage using the HTML below.

Link to this page:

Please bookmark with social media, your votes are noticed and appreciated: </p> </div> <div class="copyright"> <div class="links"> Copyright © 2016 | <a href="http://www.programmerinterview.com/jobs">Programmer Job Board</a> | <a href="http://indiajobs.programmerinterview.com/">India Job Board for Programmers</a> |  <a rel="author" href="http://www.programmerinterview.com/index.php/about/">About</a> </div> </div> </div> <script type='text/javascript'>/** * Displays toast message from storage, it is used when the user is redirected after login */ if ( window.sessionStorage ) { window.addEventListener( 'load', function () { var message = sessionStorage.getItem( 'tcb_toast_message' ); if ( message ) { tcbToast( sessionStorage.getItem( 'tcb_toast_message' ), false ); sessionStorage.removeItem( 'tcb_toast_message' ); } } ); } /** * Displays toast message */ function tcbToast( message, error, callback ) { /* Also allow "message" objects */ if ( typeof message !== 'string' ) { message = message.message || message.error || message.success; } if ( ! error ) { error = false; } let _icon = 'checkmark', _extra_class = ''; if ( error ) { _icon = 'cross'; _extra_class = ' tve-toast-error'; } jQuery( 'body' ).slideDown( 'fast', function () { jQuery( 'body' ).prepend( '<div class="tvd-toast tve-fe-message"><div class="tve-toast-message"><div class="tve-toast-icon-container' + _extra_class + '"><span class="tve_tick thrv-svg-icon"><svg xmlns="http://www.w3.org/2000/svg" class="tcb-checkmark" style="width: 100%; height: 1em; stroke-width: 0; fill: #ffffff; stroke: #ffffff;" viewBox="0 0 32 32"><path d="M27 4l-15 15-7-7-5 5 12 12 20-20z"></path></svg></span></div><div class="tve-toast-message-container">' + message + '</div></div></div>' ); } ); setTimeout( function () { jQuery( '.tvd-toast' ).hide(); if ( typeof callback === 'function' ) { callback(); } }, 3000 ); } </script><div class="et_social_pin_images_outer"> <div class="et_social_pinterest_window"> <div class="et_social_modal_header"><h3>Pin It on Pinterest</h3><span class="et_social_close"></span></div> <div class="et_social_pin_images" data-permalink="https://www.programmerinterview.com/database-sql/db2-transaction/" data-title="DB2 Transaction" data-post_id="4900"></div> </div> </div><div class="et_social_sidebar_networks et_social_visible_sidebar et_social_slideright et_social_animated et_social_rectangle et_social_sidebar_flip et_social_mobile_on"> <ul class="et_social_icons_container"><li class="et_social_facebook"> <a href="http://www.facebook.com/sharer.php?u=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&t=DB2%20Transaction" class="et_social_share" rel="nofollow" data-social_name="facebook" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_facebook"></i> <span class="et_social_overlay"></span> </a> </li><li class="et_social_twitter"> <a href="http://twitter.com/share?text=DB2%20Transaction&url=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&via=Programmerintvw" class="et_social_share" rel="nofollow" data-social_name="twitter" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_twitter"></i> <span class="et_social_overlay"></span> </a> </li><li class="et_social_pinterest"> <a href="#" class="et_social_share_pinterest" rel="nofollow" data-social_name="pinterest" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_pinterest"></i> <span class="et_social_overlay"></span> </a> </li><li class="et_social_gmail"> <a href="https://mail.google.com/mail/u/0/?view=cm&fs=1&su=DB2%20Transaction&body=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&ui=2&tf=1" class="et_social_share" rel="nofollow" data-social_name="gmail" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_gmail"></i> <span class="et_social_overlay"></span> </a> </li></ul> <span class="et_social_hide_sidebar et_social_icon"></span> </div><div class="et_social_mobile_button"></div> <div class="et_social_mobile et_social_fadein"> <div class="et_social_heading">Share This</div> <span class="et_social_close"></span> <div class="et_social_networks et_social_simple et_social_rounded et_social_left"> <ul class="et_social_icons_container"><li class="et_social_facebook"> <a href="http://www.facebook.com/sharer.php?u=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&t=DB2%20Transaction" class="et_social_share" rel="nofollow" data-social_name="facebook" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_facebook"></i> <div class="et_social_network_label"><div class="et_social_networkname">Facebook</div></div> <span class="et_social_overlay"></span> </a> </li><li class="et_social_twitter"> <a href="http://twitter.com/share?text=DB2%20Transaction&url=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&via=Programmerintvw" class="et_social_share" rel="nofollow" data-social_name="twitter" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_twitter"></i> <div class="et_social_network_label"><div class="et_social_networkname">Twitter</div></div> <span class="et_social_overlay"></span> </a> </li><li class="et_social_pinterest"> <a href="#" class="et_social_share_pinterest" rel="nofollow" data-social_name="pinterest" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_pinterest"></i> <div class="et_social_network_label"><div class="et_social_networkname">Pinterest</div></div> <span class="et_social_overlay"></span> </a> </li><li class="et_social_gmail"> <a href="https://mail.google.com/mail/u/0/?view=cm&fs=1&su=DB2%20Transaction&body=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&ui=2&tf=1" class="et_social_share" rel="nofollow" data-social_name="gmail" data-post_id="4900" data-social_type="share" data-location="sidebar"> <i class="et_social_icon et_social_icon_gmail"></i> <div class="et_social_network_label"><div class="et_social_networkname">Gmail</div></div> <span class="et_social_overlay"></span> </a> </li></ul> </div> </div> <div class="et_social_mobile_overlay"></div><div class="et_social_flyin et_social_resize et_social_flyin_bottom_right et_social_slideup et_social_mobile_on"> <a href="#" class="et_social_icon et_social_icon_cancel"></a> <div class="et_social_header"> <h3>Share This</h3> <p>Share this post with your friends!</p> </div> <div class="et_social_networks et_social_2col et_social_slide et_social_rounded et_social_left"> <ul class="et_social_icons_container"><li class="et_social_facebook"> <a href="http://www.facebook.com/sharer.php?u=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&t=DB2%20Transaction" class="et_social_share" rel="nofollow" data-social_name="facebook" data-post_id="4900" data-social_type="share" data-location="flyin"> <i class="et_social_icon et_social_icon_facebook"></i><span class="et_social_overlay"></span> </a> </li><li class="et_social_twitter"> <a href="http://twitter.com/share?text=DB2%20Transaction&url=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&via=Programmerintvw" class="et_social_share" rel="nofollow" data-social_name="twitter" data-post_id="4900" data-social_type="share" data-location="flyin"> <i class="et_social_icon et_social_icon_twitter"></i><span class="et_social_overlay"></span> </a> </li><li class="et_social_pinterest"> <a href="#" class="et_social_share_pinterest" rel="nofollow" data-social_name="pinterest" data-post_id="4900" data-social_type="share" data-location="flyin"> <i class="et_social_icon et_social_icon_pinterest"></i><span class="et_social_overlay"></span> </a> </li><li class="et_social_gmail"> <a href="https://mail.google.com/mail/u/0/?view=cm&fs=1&su=DB2%20Transaction&body=https%3A%2F%2Fwww.programmerinterview.com%2Fdatabase-sql%2Fdb2-transaction%2F&ui=2&tf=1" class="et_social_share" rel="nofollow" data-social_name="gmail" data-post_id="4900" data-social_type="share" data-location="flyin"> <i class="et_social_icon et_social_icon_gmail"></i><span class="et_social_overlay"></span> </a> </li></ul> </div> </div><script type='text/javascript' src='https://www.programmerinterview.com/wp-content/plugins/monarch/js/idle-timer.min.js?ver=1.4.13' id='et_monarch-idle-js'></script> <script type='text/javascript' id='et_monarch-custom-js-js-extra'> /* <![CDATA[ */ var monarchSettings = {"ajaxurl":"https:\/\/www.programmerinterview.com\/wp-admin\/admin-ajax.php","pageurl":"https:\/\/www.programmerinterview.com\/database-sql\/db2-transaction\/","stats_nonce":"de0d1e1fb4","share_counts":"6f35f3367a","follow_counts":"8ef24de796","total_counts":"4cfb7113dc","media_single":"bf23992d13","media_total":"4d8025fcf0","generate_all_window_nonce":"f8733568dc","no_img_message":"No images available for sharing on this page"}; /* ]]> */ </script> <script type='text/javascript' src='https://www.programmerinterview.com/wp-content/plugins/monarch/js/custom.js?ver=1.4.13' id='et_monarch-custom-js-js'></script> <script type='text/javascript' id='tve-dash-frontend-js-extra'> /* <![CDATA[ */ var tve_dash_front = {"ajaxurl":"https:\/\/www.programmerinterview.com\/wp-admin\/admin-ajax.php","force_ajax_send":"","is_crawler":"","recaptcha":[]}; /* ]]> */ </script> <script type='text/javascript' src='https://www.programmerinterview.com/wp-content/plugins/thrive-visual-editor/thrive-dashboard/js/dist/frontend.min.js?ver=2.4.0.1' id='tve-dash-frontend-js'></script> <script type='text/javascript' src='https://www.programmerinterview.com/wp-content/plugins/monarch/core/admin/js/common.js?ver=4.6.4' id='et-core-common-js'></script> <script type='text/javascript' src='https://www.programmerinterview.com/wp-includes/js/wp-embed.min.js?ver=5.5.15' id='wp-embed-js'></script> <script type="text/javascript">var tcb_post_lists=JSON.parse('[]');</script> <script type="text/javascript"> window._taboola = window._taboola || []; _taboola.push({flush: true}); </script> </body> </html>

Follow Us

Pages

DFP-300×250-1

Newsletter Subscription

Jobboard

How do transactions work in DB2? How does DB2 support transactions?

Leave a Reply Cancel reply