IIS-CONN-DB2-00691E Error code reported: SQLSTATE = SQL state: Native Error Code = Native error code: Msg = Error message


The Db2 API Error code reported an error. The SQLSTATE is SQL state. The Native Error Code is Native error code. The message returned is Error message.

Typically this error occurs when the SQL statement that was executed by the Db2 API tried to generate a value for an identity column or sequence, but all allowable values for the identity column were already assigned.

User response

Do one of the following actions:
  • Redefine the table with a larger range of values for the identity column.
  • Redefine the sequence.