Visual Explain after applying Fixpack 15 on v8.1

[fahimghauri]

Hi,

I upgraded my DB2 8.1 upto fixpack 15, before this it was on level 7.

After upgrade when I explain the Sql statement I get the following error:

------------------------------ ERROR ---------------------------------------
DBA3065E Snapshot cannot be processed due to a CLI error.

Explanation:

A CLI error has occurred during snapshot processing. An access
plan cannot be displayed.

User Response:

Check the CLI configuration by issuing the following command:

db2 get cli cfg
for section <db-name>

If LONGDATACOMPAT is set to 1, try cataloging the database with
a different alias:

catalog db <db-name> as <db-alias-name>

Set LONGDATACOMPAT=0 for the database alias:

db2 update cli cfg for section <db-alias-name> using
longdatacompat 0

Submit the query for EXPLAIN in the alias database.

If LONGDATACOMPAT is not set to 1, or the parameter is not being
set in the CLI configuration, contact IBM Service.
-------------------------------------------------------------------------------------
please help, I have run bind commands after applying fixpack.

Sincerely,