467,882 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

Catalog Database

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
  • viewed: 2641
Share:
4 Replies
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
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
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
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.

Similar topics

3 posts views Thread by maricel | last post: by
reply views Thread by xixi | last post: by
2 posts views Thread by Stefan Amann | last post: by
2 posts views Thread by sandeep.manthena | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.