Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Unanswered: Problem with Bind

    Even after running db2rbind command and
    DB2 bind @db2ubind.lst blocking all grant public
    DB2 bind @db2cli.lst blocking all grant public

    There is a problem in running the insert and update queries.

    Thsi is the error we get


    DB21034E The command was processed as an SQL statement because it was not a

    valid Command Line Processor command. During SQL processing it returned:

    SQL0805N Package "NULLID.SQLC2E06 0X4141414141634555" was not found.

    SQLSTATE=51002

    SQL0805N Package "NULLID.SQLC2E06 0X4141414141634555 " was not found.

    sqlcode : -805

    sqlstate : 51002

    Plz help


    Thanks,
    Last edited by san_suzi2004; 03-03-08 at 17:27.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Did you bind db2schema.bnd?

    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    At a command prompt, enter:

    db2 terminate
    db2 CONNECT TO <dbname>
    db2 BIND <path>/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 terminate


    Where <dbname> represents the name of a database to which the utilities should be bound, and where <path> represents the full path name of the directory where the bind files are located, such as $HOME/sqllib/bnd where $HOME represents the home directory of the instance for the database server.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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