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

What version of DB2? What version of Linux? As the instance owner, what is the output of the command "db2 list db directory"?

Andy

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 =

I do not know what the problem is. It should work as you have stated how you run it.

Andy

It should be automatically, right?

Does it has something to do with CATALOG?

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

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

What is the instance owner username?

Andy

is the db2inst3

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

export DB2INSNTANCE=db2inst3

Thanks

Rafael

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

hi!

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

Login in as db2inst3 and from the command line and connect to mydb1. What is the result?

Andy

db2 connect to mydb1

Database Connection Information

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


Works fine!

From that same session, load the Control Center (db2cc). Are the databases present?

Andy

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.