HomeDB2DB2 Error Code – -817 the insert, update, delete, ddl, or authorization statement cannot be executed because the ims/vs transaction is inquiry only

DB2 Error Code – -817 the insert, update, delete, ddl, or authorization statement cannot be executed because the ims/vs transaction is inquiry only

In this post, you’ll learn about the error message -817 the insert, update, delete, ddl, or authorization statement cannot be executed because the ims/vs transaction is inquiry only in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-817 the insert, update, delete, ddl, or authorization statement cannot be executed because the ims/vs transaction is inquiry only

Reason for the Error

One of the following situations has occurred: 1.� An application which makes local SQL queries is running as an inquiry only transaction but has attempted to execute an INSERT, UPDATE, DELETE data definition (CREATE, ALTER, or DROP), or authorization (GRANT or REVOKE) statement.� Such statements result in updates to the user data or the subsystem catalog, and cannot be executed by an application running as an inquiry only transaction. 2.� An application which does remote unit of work SQL queries has attempted to execute an INSERT, UPDATE, DELETE data definition(CREATE, ALTER, or DROP), or authorization (GRANT or REVOKE) statement.� Such statements result in updates to the user data or the subsystem catalog, and cannot be executed by an application doing remote unit of work queries.

Solution

If the application is doing local SQL queries, see your IMS/VS system programmer about changing the inquiry only status of the transaction under which your application is running.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022