In this post, you’ll learn about the error message -925 commit not valid in ims/vs or cics environment in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-925 commit not valid in ims/vs or cics environment
Reason for the Error
An application executing in either an IMS or CICS environment when DB2 is not the only resource manager has attempted to execute a COMMIT statement. The SQL COMMIT statement cannot be executed in these environments.
Solution
The IMS or CICS protocols should be used to commit work in these environments.
If a stored procedure is being called from IMS or CICS, ensure that the stored procedure is not defined to perform a commit on return.
