SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-12-13 12:30:01

BlueFin
Member

Query Plan question

Using 3.58 Pro on DB2 Express-C 10.1.2 with Win 7 Pro SP1, why am I getting a result in the message tab 'SQL0347W  The recursive common table expression "DB2ADMIN.STREAMS" may contain an infinite loop.  SQLSTATE=01605' when the query is a simple SELECT * FROM TABLE WHERE COL1 = 1 and there is an appropriate index on COL1.

I actually get the correct result query plan, but it provides the above sql error in the message tab of the result. Seems to be happening for EVERY query no matter what I use. Same thing was happening on DB2 10.1 as well prior to installing the latest fixpak version.

Another question, if I select the Query Plan toggle for an UPDATE/DELETE/INSERT .. statement, will it execute the update etc or just return the query plan ?

Offline

#2 2012-12-17 17:01:29

BlueFin
Member

Re: Query Plan question

Any ideas yet ?

Offline

#3 2012-12-18 00:29:56

sqldbxhelp
Administrator

Re: Query Plan question

This is not an error but a warning.
The statement to be explained is not executed.

Offline

#4 2013-09-23 05:14:53

Wenbin
Member

Re: Query Plan question

I think query plan function can not be used in SQLBOX

Offline

#5 2013-09-23 19:41:03

sqldbxhelp
Administrator

Re: Query Plan question

I do not now anything about SQLBOX, but in SqlDbx Professional it works

Offline

Board footer

Powered by FluxBB