How to turn off auto commit and add commit / rollback buttons to toolbar
You can switch off autocommit by clicking at the bottom left of Toad for DB2 window. If you don't see status bar at the bottom then right click to the right of the main menu and check 'status bar'.
This can be switched off in the Editor Window or on the Data tab of the Object Explorer.
Once AutoCommit is OFF, then the Commit and Rollback buttons will be available on the taskbar. The Commit and Rollback buttons cannot be moved to the main toolbar
