Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2005
    Location
    Bedfordshire, UK
    Posts
    5

    Red face Unanswered: SQL0805N on database creation

    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

  2. #2
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    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
    IBM Certified DBA for DB2 UDB
    IBM Certified Database Developer for DB2 UDB
    DB2 Tech Support, IBM Toronto Software Lab

  3. #3
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    can you try to bind db2spcat.bnd?
    I cannot find SQLE2E0G, but SQLE2E0B is in db2spcat.bnd
    IBM Certified DBA for DB2 UDB
    IBM Certified Database Developer for DB2 UDB
    DB2 Tech Support, IBM Toronto Software Lab

  4. #4
    Join Date
    Jan 2005
    Location
    Bedfordshire, UK
    Posts
    5
    Thanks, but what would I bind it to? I'm actually getting this out of a "CREATE DB" command.
    Cheers
    ChrisW

  5. #5
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    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
    IBM Certified DBA for DB2 UDB
    IBM Certified Database Developer for DB2 UDB
    DB2 Tech Support, IBM Toronto Software Lab

  6. #6
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    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 ***
    IBM Certified DBA for DB2 UDB
    IBM Certified Database Developer for DB2 UDB
    DB2 Tech Support, IBM Toronto Software Lab

  7. #7
    Join Date
    Jan 2005
    Location
    Bedfordshire, UK
    Posts
    5

    db2spcat rebound

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

  8. #8
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  9. #9
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    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
    Last edited by wangzhonnew; 11-22-05 at 13:25.
    IBM Certified DBA for DB2 UDB
    IBM Certified Database Developer for DB2 UDB
    DB2 Tech Support, IBM Toronto Software Lab

  10. #10
    Join Date
    Jan 2005
    Location
    Bedfordshire, UK
    Posts
    5

    That's done it!

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •