If it is tcpip
catalog tcpip node <node name> remote <server name or ip> server <port or service name>
catalog database <dbname> as <alias> at node <above node name>
catalog (system or user) odbc data source <alias from above>
terminate
connect to <alias name> user <user name> using <password>

Hope that helps.

-----Original Message-----
From: Mery Moreno
[mailto:db2udbdba-ezmlmshield-x92819922.[Email address protected]
Sent: Thursday, July 28, 2005 8:40 AM
To: LazyDBA Discussion
Subject: how to create an odbc connection on DB2


Gurus,

I am new in db2 would you mind to help me to create an odbc connection on db2. I tried to do one, but I encountered the following error code: [IBM][CLI Driver] SQL30061N The database alias or database or databases name XXXXXX" was not found at the remote node SQLSTATE=08004

Z/OS.
db2 version 6.1


Thanks,

Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page