Observation: Column Without Index On a Predicate
You coded a query using a column that does not use an index on a predicate. Since statistics are not generated for such a column, the Db2 optimizer applies the default filter factor to the column. This may not result in an optimal access path.
Consider using a column that has an index on the predicate, or adding an index to the column.