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.