DB2 Error Code 1196 – General error: Warning: Some non-transactional changed tables couldn’t be rolled back

In this post, you’ll learn about the DB2 error 1196-General error: Warning: Some non-transactional changed tables couldn’t be rolled back and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

1196 – General error: Warning: Some non-transactional changed tables couldn’t be rolled back

Reason for the Error & Solution

One or more tables that are being manipulated are not configured to be transactional. Tables in MySQL, by default, do not support transactions. Table type for schema creation can be configured with the TableType property of the DBDictionary configuration property.