Explain Plan does not provide output

[shafiq]

I am facing problem (DB2 ver 5)
1)I wrote a query (in command center)of almost 70 lines
2)In command center scrip-->create access plan.
The access plan for the query is not being generated. The error message
(DBA3037- The explain snapshot has been corrupted. Your request cannot be
completed.)

[Greg Nash]

Hi,

- Does your query run?
- Does the explain work if you break down your query, and work with just
a part of it?

--Greg

shafiq wrote:

> I am facing problem (DB2 ver 5)
> 1)I wrote a query (in command center)of almost 70 lines
> 2)In command center scrip-->create access plan.
> The access plan for the query is not being generated. The error message
> (DBA3037- The explain snapshot has been corrupted. Your request cannot be
> completed.)
>

[shafiq]

My Query runs successfully.
Explain Plan works well if i break the query(i.e with a part of Query).The
problem is that it does not work with the whole Query.

Shafiq

Greg Nash <GregNashdb2@bigpond.com> wrote:
>Hi,
>
>- Does your query run?
>- Does the explain work if you break down your query, and work with just

>a part of it?
>
>--Greg
>
>shafiq wrote:
>
>> I am facing problem (DB2 ver 5)
>> 1)I wrote a query (in command center)of almost 70 lines
>> 2)In command center scrip-->create access plan.
>> The access plan for the query is not being generated. The error message

>> (DBA3037- The explain snapshot has been corrupted. Your request cannot
be
>> completed.)
>>
>

[Greg Nash]

Hi,

I think I have seen this, but I can't remember the circumstances. I
think it related to a bug in optimization of OLAP queries.
My next questions:
- Does your query use any functions with a PARTITION BY clause, and
GROUP BY on some of the same columns?
- Can you create a view based on your query?
- If you create a view, can you specify SELECT * FROM viewname WHERE
(some condition that filters on the same fields as your PARTITION BY
groups on)?

--Greg

shafiq wrote:

> My Query runs successfully.
> Explain Plan works well if i break the query(i.e with a part of Query).The
> problem is that it does not work with the whole Query.
>
> Shafiq
>
> Greg Nash <GregNashdb2@bigpond.com> wrote:
>
>>Hi,
>>
>>- Does your query run?
>>- Does the explain work if you break down your query, and work with just
>>
>
>>a part of it?
>>
>>--Greg
>>
>>shafiq wrote:
>>
>>
>>>I am facing problem (DB2 ver 5)
>>>1)I wrote a query (in command center)of almost 70 lines
>>>2)In command center scrip-->create access plan.
>>>The access plan for the query is not being generated. The error message
>>>
>
>>>(DBA3037- The explain snapshot has been corrupted. Your request cannot
>>>
> be
>
>>>completed.)
>>>
>>>
>