If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Looks like explain is being called when SP is called

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-17-09, 10:20
redwolf redwolf is offline
Registered User
 
Join Date: Apr 2004
Posts: 179
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.
Reply With Quote
  #2 (permalink)  
Old 03-17-09, 10:38
D.Utro D.Utro is offline
Registered User
 
Join Date: Feb 2009
Posts: 14
EXPLAIN tables must be in default instance schema.
__________________
Best regrads,
Danny Utro.
Reply With Quote
  #3 (permalink)  
Old 03-17-09, 10:55
aflorin27 aflorin27 is offline
Registered User
 
Join Date: Apr 2008
Location: Iasi, Romania
Posts: 317
Reply With Quote
  #4 (permalink)  
Old 03-17-09, 11:27
redwolf redwolf is offline
Registered User
 
Join Date: Apr 2004
Posts: 179
My question is why is explain being run at all? We're invoking a stored procedure. We don't want an explain plan.
Reply With Quote
  #5 (permalink)  
Old 03-17-09, 11:40
D.Utro D.Utro is offline
Registered User
 
Join Date: Feb 2009
Posts: 14
See body of procedure.
__________________
Best regrads,
Danny Utro.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On