How to catalog a remote database

Posted by Eduardo Higaki Lomonaco at April 01. 2008

Hey there!

I was wondering if any1 could help me with this problem.
I need to catalog a remote dabase and i think the steps are these:

CATALOG TCPIP
NODE aix_serv
REMOTE
ip_address
SERVER 50000

CATALOG DATABASE sample AS sample_aix_serv
AT NODE aix_serv

Is there anything else I should do?

Re: How to catalog a remote database

Posted by perallis at April 01. 2008

Correct, those are the two simple steps to catalog a remote database on AIX.

Just to remember,the value of parameter "SERVER ..." must the same value of SVCENAME parameter of the instance where it is the local database. To know what is the right port number used by insatance, you have to go to local database, and issue the following command:

db2 get dbm cfg

And look to SVCENAME parameter, so now you know the port number used by instance.

Re: How to catalog a remote database

Posted by Eduardo Higaki Lomonaco at April 16. 2008

hey i found out that you should issue a terminate commando to, to refresh the nodes list!

DBA to DBA

Personal tools

Document Actions

How to catalog a remote database