Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Sep 2010
    Posts
    16

    Unanswered: Db2cc on Linux ( My Systems and Databases are empty )

    Hello friends,

    I'm starting with Db2, and I was trying to test db2 control center but I have a problem. When I start db2cc it opens normally but does not show any of my databases..nothing. I'm starting it from my instance and I believe it shouldn't be a problem.

    Can anyone help me?

    Rafael

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What version of DB2? What version of Linux? As the instance owner, what is the output of the command "db2 list db directory"?

    Andy

  3. #3
    Join Date
    Sep 2010
    Posts
    16
    Hello!

    I'm using DB2 9.7 on Linux Mint ( Ubuntu Based ).

    The output for db2 list db directory is:


    db2 list db directory

    System Database Directory

    Number of entries in the directory = 4

    Database 1 entry:

    Database alias = MYDB1
    Database name = MYDB1
    Local database directory = /home/db2inst3
    Database release level = d.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Database 2 entry:

    Database alias = M1
    Database name = MYDB1
    Node name = DB2INST3
    Database release level = d.00
    Comment =
    Directory entry type = Remote
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =

    Database 3 entry:

    Database alias = MYDB11
    Database name = MYDB1
    Node name = DB2INST3
    Database release level = d.00
    Comment =
    Directory entry type = Remote
    Authentication = SERVER
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =

    Database 4 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Local database directory = /home/db2inst3
    Database release level = d.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know what the problem is. It should work as you have stated how you run it.

    Andy

  5. #5
    Join Date
    Sep 2010
    Posts
    16
    It should be automatically, right?

    Does it has something to do with CATALOG?

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, if the DB is cataloged, then it should show up. The output you provided earlier showed 4 databases, sh those should show up as they are all cataloged. Can you connect to them as the instance owner from the command line?

    Andy

  7. #7
    Join Date
    Sep 2010
    Posts
    16
    Yes, I do!

    Check it out:


    rafael ~ # db2 connect to mydb11 ( I tried to use the alias first )
    SQL1097N The node name was not found in the node directory. SQLSTATE=42720
    rafael ~ # db2 connect to mydb1

    Database Connection Information

    Database server = DB2/LINUXX8664 9.7.2
    SQL authorization ID = ROOT
    Local database alias = MYDB1


    I also tried to catalog with another alias and I have this output ( I remember I had an error when I made the catalog procedure at the first time, don't remember if it is the same one. )

    db2 catalog database mydb1 as mydb12 at node db2inst3 authentication server
    SQL1100W The node name "db2inst3" specified in the Catalog Database command
    has not been cataloged in the Node Directory.

    Thanks!

    Rafael

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the instance owner username?

    Andy

  9. #9
    Join Date
    Sep 2010
    Posts
    16
    is the db2inst3

    This time I'm using the root user, but I exported the DB2INSTANCE varible like this:

    export DB2INSNTANCE=db2inst3

    Thanks

    Rafael

  10. #10
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you do not use the instance owner on linux, you need to setup the DB2 environment properly. Just exporting DB2INSTANCE will not work. You need to run the profile script. If you try everything as the db2inst3 user, does it work?

    Andy

  11. #11
    Join Date
    Sep 2010
    Posts
    16
    hi!

    Ialready tested this way and also using the db2inst3 user. Still empty.

  12. #12
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Login in as db2inst3 and from the command line and connect to mydb1. What is the result?

    Andy

  13. #13
    Join Date
    Sep 2010
    Posts
    16
    db2 connect to mydb1

    Database Connection Information

    Database server = DB2/LINUXX8664 9.7.2
    SQL authorization ID = DB2INST3
    Local database alias = MYDB1


    Works fine!

  14. #14
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    From that same session, load the Control Center (db2cc). Are the databases present?

    Andy

  15. #15
    Join Date
    Sep 2010
    Posts
    16
    I have this result:
    $ db2cc
    No protocol specified

    Error: Can not open display


    rafael:~ # xhost +
    rafael:~ # su - db2inst3
    db2inst3@rafael:~> export DISPLAY=:0.0
    db2inst3@rafael:~> db2cc

    Control Center starts, but still empty.

Posting Permissions

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