db2exfmt and missing function EXPLAIN_FORMAT_STATS

[=?ISO-8859-2?Q?Gregor_Kova=E8?=]

Hi!

when I run db2exfmt on DB2 9.1 I get this output:
DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp.
1991, 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Explain Table Format Tool

Connecting to the Database as user EMGSYS.
Connect to Database Successful.
Binding package - Error during Bind, near line 1484.

Error Message =
SQL0001N Binding or precompilation did not complete successfully.
SQLCA
Size = 136
SQLCODE = -1
Tokens = /home/gregor/sqllib/bnd/db2exfmt.bnd
Function= sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =

Error during bind.
Bind messages can be found in db2exfmt.msg
and db2exfmt.msg says:
LINE MESSAGES FOR db2exfmt.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
9076 SQL0440N No authorized routine named "EXPLAIN_FORMAT_STATS"
of type "FUNCTION" having compatible arguments was found.
SQLSTATE=42884
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

How to solve this?

Best regards,
Kovi

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[mirof007]

Hi, I would simply try running db2 -tvf ~/sqllib/misc/EXPLAIN.DDL
again. I'm assuming you originally created the explain tables on an
earlier version, it could be that some new explain related functions
were added to the script in Version 9.

Hope this helps,
Miro

[=?ISO-8859-1?Q?Gregor_Kovac=28?=]

Hi!

Yes, I tried that and the script complained that there is no
SYSPROC.EXPLAIN_GET_MSG2 function, which led me to conclusion that
Databse Instance was not migrated, but running db2imirgr sayed that it
cannot migrate the instance since it already is migrated. Go figure.
Now I'm wandering in the dark.

Best regards,
Kovi

mirof007 pravi:

Hi, I would simply try running db2 -tvf ~/sqllib/misc/EXPLAIN.DDL
again. I'm assuming you originally created the explain tables on an
earlier version, it could be that some new explain related functions
were added to the script in Version 9.

Hope this helps,
Miro

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[Serge Rielau]

Gregor Kovac wrote:

Hi!

Yes, I tried that and the script complained that there is no
SYSPROC.EXPLAIN_GET_MSG2 function, which led me to conclusion that
Databse Instance was not migrated, but running db2imirgr sayed that it
cannot migrate the instance since it already is migrated. Go figure.
Now I'm wandering in the dark.

It seems like you are using a db2exfmt of DB2 9.5 against DB2 9.1.
Are you running this from a Db2 9.5 client perhaps?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab