Unanswered: Unresolved QNC found... What should that mean???
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.