--- Robert Broderick <[EMAIL PROTECTED]> wrote: > What is needed to set up a DB2 ODBC remote entry for DB2 on an AIX machine > running 5.0 broker. We have an ODBC entry for a local DB2 on the same box > but need a access to a remote DB2 DB???? > > bobbee
Just catalog the remote node and the database on your AIX machine, then the ODBC entry will look no different from the one you setup for local databases. Login as the instance owner and issue the following commands: db2 "catalog tcpip node <node-name> remote <hostname> server <port-number>" db2 "catalog db <database-name> as <database-alias> at node <node-name>" Then in your .odbc.ini add a line under ODBC Data Sources, and create a new stanza with the <database-alias> name: [ODBC Data Sources] <path to driver>=LTCSHARE=IBM DB2 ODBC Driver [<database-alias>] Driver=<path to driver> Description=bobbee's remote database Database=<database-alias> HTH, Peter Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive