Hi All,

The execution of a "quite" complex query works fine untill I try to select the count of the returned rows:

select count (t1.a) from (select a,b,c, from T1,T2,T3...where...) t1

executing this DB2 (7.2 UDB FP7 on AIX) returns following message:

[IBM][CLI Driver][DB2/6000] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Bad Plan; Unresolved QNC found".) SQLSTATE=58004

Has anybody seen this message before?
DB2-help suggests to send a tracefile,... to IBM.

I would be grateful if someone among you could help me to understand or to solve this.