CHC0792I

CHC0792I The Row Filtering Expression for table name will be used as a SQL WHERE 
clause during the Table Refresh.

Explanation—The row filtering expression defined for the identified source table will be treated as a SQL WHERE clause in the SELECT statement that implements a refresh. If a correctly formed CDC Replication row selection expression is treated as a SQL WHERE clause, refresh performance improves significantly when a small percentage of the rows in a large table are selected for refresh. To realize the possible improvements in refresh performance, the row filtering expression must be a correctly formed standard CDC Replication row filtering expression and also a syntactically correct search-condition operand of the WHERE keyword in an SQL WHERE clause. In addition, the SQLWHEREROWSEL keyword in the DB2® configuration control statement must be set to YES.

Message Variables:

name—The name of the source table for which a row filtering expression has been defined.

Message Destination—Product administration log

System Action—None

Operator Response—None

Client Administrator Response—If the row filtering expression cannot be treated as a SQL WHERE clause, make sure that the expression is correctly formed, and the SQLWHEREROWSEL keyword is set to YES.