I'm using the explain tool from Candle (now IBM) but this week something
strange happened.
For 'filling' the tool I run an extraction job on the DB2 catalog.
But since this week the extraction job doesn't extract any SQL statement
anymore.
So the packages in the tool are empty and not explainable.
The applications are working fine so there is something in the extract
mechanism what causes the problem, I think.
It;'s the precompile date what makes the difference. All packages with
precompile date > 22082005 seems to be empty.
Older packages are fine even if bounddate is >22082005

Thanks for reading, any suggestions?
********************************DISCLAIMER********************************
Deze e-mail en alle daarbij meegezonden bijlagen zijn uitsluitend bestemd
voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is
niet toegestaan. Delta Lloyd N.V. en haar dochtermaatschappijen sluiten
iedere aansprakelijkheid uit die voortvloeit uit elektronische verzending.

This e-mail and any attachment sent with it are intended exclusively for
the addressee(s), and may not be passed on to, or made available for use
by any person other than the addressee(s). Delta Lloyd N.V. and its
subsidiaries rule out any and every liability resulting from any electronic
transmission.
***************************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page