Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: Looks like explain is being called when SP is called

    When I call a stored procedure I get the following error msg, indicating the explain facility is attempting to run. Does anyone know what maybe occurring here to cause explain to run by itself?

    C:\>db2 call liq.sp_igis_ost_por_alloc('ZONE1')
    SQL0727N An error occurred during implicit system action type "5".
    Information returned for the error includes SQLCODE "-219", SQLSTATE "42704"
    and message tokens "LIQREP.EXPLAIN_INSTANCE". SQLSTATE=56098

    C:\>db2 ? SQL0219


    SQL0219N The required Explain table "<name>" does not exist.

    Explanation:

    The Explain facility has been invoked but was unable to find the
    required Explain table "<name>". The Explain tables must be
    created prior to invoking Explain.

    User Response:

    Create the required Explain tables. The SQL Data Definition
    Language statements needed to create the Explain tables are
    available in the file called EXPLAIN.DDL in the misc directory
    under sqllib.

  2. #2
    Join Date
    Feb 2009
    Posts
    14
    EXPLAIN tables must be in default instance schema.
    Best regrads,
    Danny Utro.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2

  4. #4
    Join Date
    Apr 2004
    Posts
    190
    My question is why is explain being run at all? We're invoking a stored procedure. We don't want an explain plan.

  5. #5
    Join Date
    Feb 2009
    Posts
    14
    See body of procedure.
    Best regrads,
    Danny Utro.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •