Hi All,
Im trying to run db2expln over some sql in order to find out why its
so slow.
I receive the following error message.
LINE MESSAGES FOR DYNEXPLN.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
1 SQL1185N FEDERATED "NO" is incorrectly used in binding the
package.
SQL0091W Precompilation or binding was ended with "1"
errors and "0" warnings.
SQL1185N is telling me that FEDERATED isnt set - "...In this case, you
must specify FEDERATED YES to bind the package.". The federated param
is set, as Im running sql at the command line using federated tables.
I set the federated value again, but wil no success.
"db2 update dbm cfg using federated yes"
Can anyone suggest how to resolve this, or a better way to analyse
slow running SQL.
Thanks
Terry