DB2 cataloging

[harikhk]

Hi,

I am able to catalog a database from DS AIX server.
The query is "Is it possible to catalog two databases with same names which are mounted on two different servers".If so how can I do this

The situation is as below
Server 1 : ABC DatabaseName : APPLE1
Server2 : DEF DatabaseName : APPLE2

Datastage server is same for both the environments(Development and Test) with same database names.

I did try to catalog with different nodes and when I execute to catlog database I receive below message

db2 "catalog tcpip node SERVER2 remote xx.xxx.xx.xx server 50000"
db2 "catalog database APPLE1 at node SERVER2"

SQL1005N The database alias "APPLE1" already exists in either the local
database directory or system database directory

Please help me to understand how to have same DSN Name for two environments

[rkashyap]

Look into the ALIAS option ofDB2 Catalog database command:

Code: Select all

db2 "catalog database APPLE1 as <ALIAS> at node SERVER2"

[harikhk]

Thanks. It worked :D