On trying to create a database, I got the following:
================================================== ========
SQL0805N Package "NULLID.SQLE2E0G 0X4141414141524155" was not found. SQLSTATE=51002
================================================== ========

T0 the best of my knowledge, no changes have been made to the db2 instance since I last did any work here. After going round in circles for a while, I went to a "neutral" instance and did:

================================================== ========
uk01ut05db $ db2sampl
SQL0805N Package "NULLID.SQLE2E0G 0X4141414141524155" was not found. SQLSTATE=51002
uk01ut05db $ db2level
DB21085I Instance "ui1sys" uses "32" bits and DB2 code release "SQL08020" with
level identifier "03010106".
Informational tokens are "DB2 v8.1.1.72", "s040914", "U498350", and FixPak "7".
Product is installed at "/usr/opt/db2_08_01".
================================================== ========

I'm now at a complete loss, since all references to SQL0805N errors that I can find seem to relate to extant databases.

Help!

ChrisW

it caused by you missing package SQLE2E0G. I'm not sure which .bnd file is that package located. give me sometime but i cannot promise i'll find it

can you try to bind db2spcat.bnd?
I cannot find SQLE2E0G, but SQLE2E0B is in db2spcat.bnd

Thanks, but what would I bind it to? I'm actually getting this out of a "CREATE DB" command.
Cheers
ChrisW

please use db2bfd command to find if that package located in that .bnd file:
http://publib.boulder.ibm.com/infoce...69%6e%64%22%20

try to use rebind command and bind that package and I hope it will solve your problem

C:\Program Files\IBM\SQLLIB\bnd>db2bfd -b db2spcat.bnd

db2spcat.bnd: Header Contents

Header Fields:

Field Value
----- -----
releaseNum 0x800
Endian 0x4c
numHvars 19
maxSect 8
numStmt 90
optInternalCnt 4
optCount 10


Name Value
------------------ -----
Isolation Level Cursor Stability
Creator "NULLID "
App Name "SQLE2E0G"
Timestamp "AAAAARAU:User defined timestamp"
Cnulreqd Yes
Sql Error No package
Block Block All
Validate Bind
Date Default/local
Time Default/local


*** All other options are using default settings as specified by the server ***

db2spcat.bnd Does contain SQLE2EOB but not SQLE2EOG. Rebindind it doesn't appear to have made any difference...

Have you try this

o "DB2 bind @db2ubind.lst blocking all grant public" for the
DB2 utilities.

o "DB2 bind @db2cli.lst blocking all grant public" for CLI.

Description of this error call for these binds.

emm... yeah, in s040914 it seems only contains SQLE2EOB.
SQLE2EOG shouldn't appear in fp7a....
please open IBM PMR for that lol

seems SQLE2EOG only contains in fp9 and fp10. don't know why it shows on fp7a

I did try the ubind & cli earlier. I've just copied the db2spcat.bnd from our FP10 development box & that seems to have done the trick. Thanks for the help guys!

ChrisW