SQL containing “select distinct” was used, and some user defined fields (Expressions) requested. “Select distinct” should only be used with whole DB2 fields.
SQL containing “select distinct” is passed to DB2, but additional columns not seen by the user might be requested that result in apparent duplicate rows being returned.
Verify that “select distinct” is having a meaningful effect.