-20252   DIAGNOSTICS AREA FULL. NO MORE ERRORS CAN BE RECORDED FOR THE NOT ATOMIC STATEMENT

Explanation

A statement with the NOT ATOMIC CONTINUE ON SQLEXCEPTION clause encountered more errors than could be recorded in the diagnostics area. NOT ATOMIC processing with CONTINUE ON SQLEXCEPTION allows DB2® to continue processing a statement after one or more errors is encountered. DB2 will continue processing until it is no longer able to record errors in the diagnostic area (See the GET DIAGNOSTICS statement for information on how to retrieve error information). When DB2 is no longer able to record error diagnostics, processing of the statement is terminated, and this error is returned.

System action

The statement is terminated.

Programmer response

Analyze the warning and error conditions using the GET DIAGNOSTICS statement. Determine how to change the statement to eliminate or reduce the number of warnings and errors. It is up to the programmer to determine if a ROLLBACK or COMMIT should be issued for this message. Either is appropriate depending on the application logic.

SQLSTATE

429BI