DB2 SQL-Error: -925
SQLState: 51006
Short Description: COMMIT NOT VALID IN IMS CICS OR RRSAF ENVIRONMENT C ROLLBACK NOT VALID IN IMS CICS OR RRSAF ENVIRONMENT THE LANGUAGE INTERFACE LI WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND
An application executing in either an IMS or CICS environment or an application executing in an RRSAF 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. System action: The statement cannot be executed. No commit is performed. Programmer response: The IMS, CICS or RRS 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. SQLSTATE: 2D521 Explanation: An application executing in either an IMS or CICS environment or an application executing in an RRSAF environment when DB2 is not the only resource manager has has attempted to execute a ROLLBACK statement. The SQL ROLLBACK statement cannot be executed in these environments. System action: The statement cannot be executed. No roll back is performed. Programmer response: The IMS, CICS or RRS protocols should be used to rollback work in these environments. SQLSTATE: 2D521 Explanation: In the TSO environment, the user has attempted to execute an application program without first establishing the correct execution environment by issuing the DSN command. In the IMS, CICS, or call attachment facility (CAF) environment, the user has attempted to execute an application program that is not using the correct language interface module. System action: The statement cannot be executed. Programmer response: In the TSO environment, DB2 application programs should be invoked under the RUN subcommand of the DSN command processor. In the IMS, CICS or CAF environment check that the application was link-edited with or is dynamically allocating the correct language interface module. The language interface modules required in each environment are as follows: v IMS: DFSLI000 v CICS: DSNCLI v CAF: DSNALI v TSO: DSNELI The DYNAM option can result in the incorrect language interface module being loaded at runtime.