By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Catalog Database

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.