db2exsrv

[John]

I have DB2 personal edition (v8.1 fixpack 10) installed and trying to
execute DB2EXPLN. I'm getting the following error. Has anybody else
experienced this?

HERE IS THE COMMAND I'M EXECUTING...

db2expln -database sales_db -stmtfile c:\misc\explain_sql.txt -terminator ; -terminal

AND THIS IS THE ERROR I'M GETTING...
Error during explain call.
Message Text =
SQL0444N Routine "explain" (specific name "SQL060216090633710") is
implemented with code in library or path "\db2exsrv", function
"explain"
which cannot be accessed. Reason code: "4". SQLSTATE=42724
sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -444
sqlstate = 42724
sqlerrml = 46
sqlerrmc = "explain", "SQL060216090633710", "\db2exsrv", "explain",
"4"
sqlerrp = SQLERLIB
sqlerrd0 = 0x00000000 = 0
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0x00000000 = 0
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

[Mark A]

"John" <jo**********@yahoo.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

I have DB2 personal edition (v8.1 fixpack 10) installed and trying to
execute DB2EXPLN. I'm getting the following error. Has anybody else
experienced this?

HERE IS THE COMMAND I'M EXECUTING...

db2expln -database sales_db -stmtfile c:\misc\explain_sql.txt -terminator
; -terminal

AND THIS IS THE ERROR I'M GETTING...
Error during explain call.
Message Text =
SQL0444N Routine "explain" (specific name "SQL060216090633710") is
implemented with code in library or path "\db2exsrv", function
"explain"
which cannot be accessed. Reason code: "4". SQLSTATE=42724
sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -444
sqlstate = 42724
sqlerrml = 46
sqlerrmc = "explain", "SQL060216090633710", "\db2exsrv", "explain",
"4"
sqlerrp = SQLERLIB
sqlerrd0 = 0x00000000 = 0
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0x00000000 = 0
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

What does the Messages and Codes manual say about that error message and
reason code?

[John]

The -444 (reason code of 4) says file in library or path can notbe
found. I'm assumiing it's looking for something called db2exsrv. I
can't find any module/dll/etc... with that name on my workstation.

[Mark A]

"John" <jo**********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

The -444 (reason code of 4) says file in library or path can notbe
found. I'm assumiing it's looking for something called db2exsrv. I
can't find any module/dll/etc... with that name on my workstation.

Sounds like you may have a bad install, or a bad pathlib. I would first do a
complete search of the server for the filename db2exsrv.*

[Bob [IBM]]

C:\Program Files\IBM\SQLLIB>dir /s db2exs*.*
Volume in drive C has no label.
Volume Serial Number is D876-CE59

Directory of C:\Program Files\IBM\SQLLIB\bnd

04/24/2005 11:50 AM 8,906 db2exsrv.bnd
1 File(s) 8,906 bytes

Directory of C:\Program Files\IBM\SQLLIB\FUNCTION

05/26/2005 03:06 PM 278,528 db2exsrv.dll
1 File(s) 278,528 bytes

Total Files Listed:
2 File(s) 287,434 bytes
"Mark A" <no****@nowhere.com> wrote in message
news:Lc******************************@comcast.com. ..
| "John" <jo**********@yahoo.com> wrote in message
| news:11**********************@g14g2000cwa.googlegr oups.com...
| > The -444 (reason code of 4) says file in library or path can notbe
| > found. I'm assumiing it's looking for something called db2exsrv. I
| > can't find any module/dll/etc... with that name on my workstation.
| >
|
| Sounds like you may have a bad install, or a bad pathlib. I would first do a
| complete search of the server for the filename db2exsrv.*
|
|

[Gert van der Kooij]

In article <11*********************@g47g2000cwa.googlegroups. com>,
John (jo**********@yahoo.com) says...

I have DB2 personal edition (v8.1 fixpack 10) installed and trying to
execute DB2EXPLN. I'm getting the following error. Has anybody else
experienced this?

HERE IS THE COMMAND I'M EXECUTING...

db2expln -database sales_db -stmtfile c:\misc\explain_sql.txt -terminator ; -terminal

AND THIS IS THE ERROR I'M GETTING...
Error during explain call.
Message Text =
SQL0444N Routine "explain" (specific name "SQL060216090633710") is
implemented with code in library or path "\db2exsrv", function
"explain"
which cannot be accessed. Reason code: "4". SQLSTATE=42724

If you didn't create the sales_db with this version/fixpack you might
need to run db2updv8 against it.

[johnl]

I've tried running db2updv8 and I get the dreaded "DB2UPDV8 processing
failed for database 'sales_db'" message. I'll keep plugging away and
try to figure out why DB2UPDV8 is not working.

[Gert van der Kooij]

In article <11*********************@o13g2000cwo.googlegroups. com>,
johnl (jo*********@yahoo.com) says...

I've tried running db2updv8 and I get the dreaded "DB2UPDV8 processing
failed for database 'sales_db'" message. I'll keep plugging away and
try to figure out why DB2UPDV8 is not working.

Did you see any error message in the db2diag log?

[johnl]

No, nothing in the db2diag.log. The last entry in there is me starting
DB2. Nothing in the event viewer as well. I get the same error
whether I put in a bogus database name or not. It fails right away...