Catalog Database

bikkaran

Hi ,

I want to catalog a database and I have the follwoing information with
me.
Node name = abcdef
Comment =
Protocol = TCPIP
Hostname = abcdef.portsmouth.uk.ibm.com
Service name = 5912

I have a database XYZ that is residing in
abcdef.portsmouth.uk.ibm.com . I dont know this database is in which
instance . I have to find out that . as that is required whiile
catalogging the Database.

Now I want to catalog this from Server1 . The current instance in
Server1 is db2inst0
I am using the following command to catalog .

db2 catalog tcpip node abcdef.portsmouth.uk.ibm.com server 5912
OSTYPE AIX . <--------- this command works perfectly
alright ...but I need to specify the remote instacne name .

.. how to get that ..????

Apr 5 '06 #1

m

bi******@in.ibm.com wrote:

Hi ,

I want to catalog a database and I have the follwoing information with
me.
Node name = abcdef
Comment =
Protocol = TCPIP
Hostname = abcdef.portsmouth.uk.ibm.com
Service name = 5912

I have a database XYZ that is residing in
abcdef.portsmouth.uk.ibm.com . I dont know this database is in which
instance . I have to find out that . as that is required whiile
catalogging the Database.

Now I want to catalog this from Server1 . The current instance in
Server1 is db2inst0
I am using the following command to catalog .

db2 catalog tcpip node abcdef.portsmouth.uk.ibm.com server 5912
OSTYPE AIX . <--------- this command works perfectly
alright ...but I need to specify the remote instacne name .

. how to get that ..????

The correct syntax for the statement is:

db2 catalog tcpip node <nodename> remote <servername or IP> server
<instance port>

then db2 catalog database XXX at node <nodename>

Apr 5 '06 #2

situ

try this

db2 catalog tcpip node xyz remote abcdef.portsmouth.uk.ibm.com server
5912 or try

db2 catalog tcpip node xyz remote abcdef.portsmouth.uk.ibm.com server
db2inst0

or else try it through configaration assistent

Apr 5 '06 #3

Knut Stolze

situ wrote:

try this

db2 catalog tcpip node xyz remote abcdef.portsmouth.uk.ibm.com server
5912 or try

db2 catalog tcpip node xyz remote abcdef.portsmouth.uk.ibm.com server
db2inst0

or else try it through configaration assistent

It does work now. There was just a misunderstanding regarding the necessity
to specify the name of the remote instance in the CATALOG command.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Apr 5 '06 #4

bikkaran

Hi ,

Learning :
1.There is indeed no need to specify the instance name or else even we
can specify the current istance of our server.
2. Once you have catalogged try to attach to the node using the
following command :
db2 attach to node_name user user_name using pass_word.
<----------If it completes successful , our catalogging task has been
confirmed succes.

Thanks a lot every one..
bikash

Apr 6 '06 #5