DB2 SQL-Error: -901
SQLState: 58004
Short Description: UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS
A system error occurred that prevented successful execution of the current SQL statement. However, the error does not prevent successful execution of further SQL statements. The error might occur if the length of the SQL statement is less than 0, or is greater than the DB2 maximum length for a statement. This SQLCODE might also occur when distributed commit processing encounters an error. In this case, all servers in the unit of work that support distributed two-phase commit backed out the unit of work. If a server that does not support distributed two-phase commit has updates in the unit of work, that server must be queried to determine if its updates were committed or backed out. Finally, this error might occur during commit if post-processing cannot be completed because of an update that changes the partition of a row. Resource unavailable problems can prevent the post-processing from completing. The existence of held cursors can prevent the post-processing from completing. Commit is failed. The transaction is aborted. System action: The statement cannot be executed. A X'04E' abend might be requested for the application. The application program can have a recovery routine to recover from such an abend and can retry SQL statements. Programmer response: If an abend occurred, notify the system programmer for analysis of the abend that caused this return code. Even if an abend occurred, an application program receiving this return code can retry and is not prohibited from executing further SQL statements.