CHC1433W

CHC1433W  %GETCOL statement for table table requires a multiple index} scan. This 
will adversely affect performance.

Explanation—A %GETCOL function call in an expression defined in Management Console requires a DB2® scan of multiple indexes for the named table. An index scan is being performed each time a record is updated, and will likely deteriorate overall performance. This deterioration in performance is significant if the table is not small.

Message Variables:

table—The name of the table that contains the column that invokes the %GETCOL function through an expression.

Message Destination—Product administration log

System Action—None

Operator Response—None

Client Administrator Response—If performance is unacceptable, use different or additional key columns (if they exist in the primary table) to retrieve a secondary table column with the %GETCOL function call. Using different or additional key columns may cause the %GETCOL function to generate SQL statements that circumvent the need for a Db2® index scan.