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.