Explain Plan does not provide output


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Explain Plan does not provide output

  1. #1
    shafiq Guest

    Explain Plan does not provide output


    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.)

  2. #2
    Greg Nash Guest

    Re: Explain Plan does not provide output

    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.)
    >



  3. #3
    shafiq Guest

    Re: Explain Plan does not provide output



    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.)
    >>

    >



  4. #4
    Greg Nash Guest

    Re: Explain Plan does not provide output

    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.)
    >>>
    >>>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center