Hello everybody,

I'm getting the follwing error when I start db2expln or dynexpln.

I have install DB2 V8.1 without FP on Windows XP. Also I have install GCC.

C:\DB2\IBM\SQLLIB\BIN>db2level

DB21085I Exemplar "DB2" verwendet "32" Bit und DB2-Codefreigabe "SQL08010"
mit
Aktualitäts-ID "01010106".
Informationstokens: "DB2 v8.1.0.36", "s021023", "" und FixPak "0".
Produkt ist auf "C:\DB2\IBM\SQLLIB" installiert.

C:\DB2\IBM\SQLLIB\BIN>db2set -all

[e] DB2PATH=C:\DB2\IBM\SQLLIB
[i] DB2_SQLROUTINE_COMPILE_COMMAND=C:\DB2\GCC\sample-db2gcc-smm.bat
SQLROUTINE_FILENAME
[i] DB2_BINSORT=YES
[i] DB2INSTPROF=C:\DB2\IBM\SQLLIB
[i] DB2COMM=TCPIP
[i] DB2_PARALLEL_IO=*
[g] DB2SYSTEM=WINDOWSXP
[g] DB2PATH=C:\DB2\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00


C:\DB2\IBM\SQLLIB\BIN>db2expln -d db2test -z ';' -f
C:\DB2\SQL\sql22.txt -g -i -o db2expln.sql22.out

DB2 Universal Database Version 8.1, 5622-044 (c) Copyright IBM Corp. 1991,
2002
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool

Error during explain call.

Message Text =
SQL0444N Die Routine "explain" (spezifischer Name "SQL030824084333820")
ist durch Code in Bibliothek oder Pfad "\db2exsrv", Funktion "explain"
implementiert, auf die kein Zugriff möglich ist. Ursachencode: "4".
SQLSTATE=42724


sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -444
sqlstate = 42724
sqlerrml = 46
sqlerrmc = "explain", "SQL030824084333820", "\db2exsrv", "explain", "4"
sqlerrp = SQLERLIB
sqlerrd0 = 0x8037006D = -2143879059
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0x00000000 = 0
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '


Output is available in "db2expln.sql22.out".



Has anyone an idea ?

Gruss / Regards Stefan

Can you take a look in sqllib\function on your server? Does db2exsrv.dll
exist? It should.
--
__________________________________________________ ___________________
Doug Doole
DB2 Universal Database Development
IBM Toronto Labs

DB2 UDB v8.1 is available for AIX, HP, Linux, Solaris and Windows
http://www-3.ibm.com/software/data/db2/udb/v8/

Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.ibm.com/software/data/db2...s2unix/support

The function is not on my computer. How can I get (after-install) it?

Gruss / Regards Stefan