-918   THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE A CONNECTION HAS BEEN LOST

Explanation

Execution of the SQL statement failed because a communications link between the local DB2® and at least one remote server no longer exists. A previous failure caused this condition.

System action

In the IMS™ and CICS® environments, all SQL statements are rejected until the rollback occurs. In the other environments, all SQL statements other than a static ROLLBACK are rejected until a static ROLLBACK is executed.

Programmer response

In general, an application program should issue a static ROLLBACK. Attempts by the application to issue SQL statements other than static ROLLBACK might fail. Once the static ROLLBACK is issued, the application can resume execution.

SQLERRP contains the name of the module that detected the previous failure and placed the application in the must-abort state.

SQLSTATE

51021