Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Angry Unanswered: Seeing db2 7.2 db with db2 8.1

    We've been working with db2 7.2 and now we are moving to db2 8.1. We have several development databases on db2 7.2 (Windows and Solaris environments).
    I installed a copy of db2 8.1 in my machine to start playing around with the new functionality.
    I have no problems creating and managing a local database, but when I try to connect to a db2 7.2 database that is on someother server it doesn't let me look at it. I get the following message in control center:
    SQL0805N Package "NULLID.SYSSH100" was not found. SQLSTATE=51002.
    I assummed that you could see and manage databases previously created in db2 7.2 with the db2 8.1 client. isn't it?
    What do I need to do to correct this.

    Carlos

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Seeing db2 7.2 db with db2 8.1

    From the client , connect to the server and do

    db2 bind @~/sqlllib/bnd/db2cli.lst blocking all grant public
    db2 bind @~/sqlllib/bnd/db2ubind.lst blocking all grant public


    Cheers
    Sathyaram

    Originally posted by CRGB
    We've been working with db2 7.2 and now we are moving to db2 8.1. We have several development databases on db2 7.2 (Windows and Solaris environments).
    I installed a copy of db2 8.1 in my machine to start playing around with the new functionality.
    I have no problems creating and managing a local database, but when I try to connect to a db2 7.2 database that is on someother server it doesn't let me look at it. I get the following message in control center:
    SQL0805N Package "NULLID.SYSSH100" was not found. SQLSTATE=51002.
    I assummed that you could see and manage databases previously created in db2 7.2 with the db2 8.1 client. isn't it?
    What do I need to do to correct this.

    Carlos
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Posts
    6

    Re: Seeing db2 7.2 db with db2 8.1

    It did not work.... any other Idea?

    Originally posted by sathyaram_s
    From the client , connect to the server and do

    db2 bind @~/sqlllib/bnd/db2cli.lst blocking all grant public
    db2 bind @~/sqlllib/bnd/db2ubind.lst blocking all grant public


    Cheers
    Sathyaram

Posting Permissions

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