DB2 cataloging
Posted: Tue Aug 25, 2015 1:55 pm
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
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