DB2 -925 2D521 SQL的COMMIT语句不能从CICS或IMS/TM发布 如何解决

Question

Java 调用dB2存储过程报了这个错误
Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -925, SQLSTATE: 2D521, SQLERRMC: null
不知道如何处理，求大神解答

Answer 1

自己顶一下百度没看懂
Explanation: COMMIT is disallowed in the following cases:
In a Distributed Transaction Processing environment such as CICS, a static SQL COMMIT statement was attempted, but a commit statement specific to the environment is required. For example, in a CICS environment this would be the CICS SYNCPOINT command.
A DB2 application precompiled or set to use CONNECT 2 in a non-TP Monitor environment has issued a dynamic SQL COMMIT statement, whereas only static SQL COMMITs are allowed.
When issued from a stored procedure, SQL COMMIT is also not allowed if the calling program is executing in a distributed unit of work or Distributed Transaction Processing environment.
User Response: Correct the problem by doing one of the following:
Remove the statement issuing the COMMIT and replace it with a statement which does the valid equivalent for the environment
In the case of a connect type 2 in a non-TP Monitor environment, use only static COMMIT.
In the case of a stored procedure, remove the COMMIT