DataStage and IBM's Universe Database
Posted: Sat May 24, 2003 9:29 am
This message is related to the one Hendrik Kotze posted earlier. When one makes an entry in the uvodbc.config file (when there are co-resident universe databases on the server running under Windows 2000), how does DataStage/Universe know which database to access.For example:
[ODBC DATA SOURCES]
DBMSTYPE = UNIVERSE
network = LAN
service = uvserver
host = localhost
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = cfs-mark
The only difference is the host name. However, in this case, they are the same server. In DataStage, when one tries to import a Universe account using 'Universe Tables' instead of ODBC, DataStage defaults to the accounts in localuv and seems to ignore the 'account' entry one is prompted for.
Accessing a remote Universe database (10.0.4) with DataStage 6.0
If one uses the uvodbc.config route, is it necessary to create any other entries in DataStage or Universe e.g Does one have to make an entry in the UV.ACCOUNTS file in DataStage UV? Does some entry have to exist in UVNET II? Also, what role does the HOSTS file play in all this?
Any help would be much appreciated. IBM have acknowledged they have connection problems in Universe ver 10.0.4, but have not been specific enough for us to discount the problem and force a Universe upgrade to the next version.
Thanks
[ODBC DATA SOURCES]
DBMSTYPE = UNIVERSE
network = LAN
service = uvserver
host = localhost
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = cfs-mark
The only difference is the host name. However, in this case, they are the same server. In DataStage, when one tries to import a Universe account using 'Universe Tables' instead of ODBC, DataStage defaults to the accounts in localuv and seems to ignore the 'account' entry one is prompted for.
Accessing a remote Universe database (10.0.4) with DataStage 6.0
If one uses the uvodbc.config route, is it necessary to create any other entries in DataStage or Universe e.g Does one have to make an entry in the UV.ACCOUNTS file in DataStage UV? Does some entry have to exist in UVNET II? Also, what role does the HOSTS file play in all this?
Any help would be much appreciated. IBM have acknowledged they have connection problems in Universe ver 10.0.4, but have not been specific enough for us to discount the problem and force a Universe upgrade to the next version.
Thanks