Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2002
    Location
    USA
    Posts
    53

    Unanswered: SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.

    Hi,

    I got
    DBD:B2::db prepare failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
    DBD:B2::st execute failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
    Can't execute statement: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002

    Sun Solaris 10, DB2 V9.
    bash-3.00$ db2level
    DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09010"
    with level identifier "02010107".
    Informational tokens are "DB2 v9.1.0.0", "s060629", "SUN64", and Fix Pack "0".
    Product is installed at "/opt/IBM/db2/V9.1".


    Thanks a lot.

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    rebind the packages

  3. #3
    Join Date
    Jan 2002
    Location
    USA
    Posts
    53
    more detail?

    Thanks.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    db2 connect to ...
    db2 bind @/opt/IBM/db2/V9.1/bnd/db2cli.lst blocking all grant public
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2002
    Location
    USA
    Posts
    53
    I did it
    bash-3.00$ db2 bind /opt/IBM/db2/V9.1/bnd/@db2cli.lst blocking all grant public

    LINE MESSAGES FOR db2cli.lst
    ------ --------------------------------------------------------------------
    SQL0061W The binder is in progress.
    SQL0091N Binding was ended with "0" errors and "0" warnings.

    But still got
    DBD:B2::db prepare failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
    DBD:B2::st execute failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
    Can't execute statement: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002

    Thanks

  6. #6
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    just check case 2 at following tech article

    http://www-128.ibm.com/developerwork...ex.html#N10AB6

    --Rahul

  7. #7
    Join Date
    Jan 2002
    Location
    USA
    Posts
    53
    Great! it works!!!
    thanks a lot.

    -Jianrong

Posting Permissions

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