DSNE615I NUMBER OF ROWS AFFECTED IS nn
Explanation
This message is written to the output data set following execution of an SQL data change statement, or REFRESH statement. nn is a count of the number of rows that qualified to be deleted, inserted, or updated by that statement, excluding rows affected by either triggers or referential integrity constraints. If the previous SQL statement is a multiple-row FETCH, nn indicates the number of rows fetched.
Note: In
the case of a mass delete of a table in a segmented table space, or
a delete from a view when neither the DELETE statement nor the definition
of the view included selection criteria, this message will not be
displayed. In these cases, Db2 does
not access nor count the individual rows.
System action
Input data set processing is completed, and this message is included in the SPUFI output.