Dear ALL,
I was trying to connect to a remote AIX DB2 database from a Windows
2000 machine in two ways:
1) Use DB2 client in Windows to connect to the cataloged DB
I typed "db2 connect to mydb user myuser using mypassword" in the DB2
command line. The connection is nearly instant.
2) Configured ODBC datasource in Windows
I configured an system ODBC datasource in Windows (Control Panel ->
Administrative Tools -> Data Sources (ODBC)) to point to the remote
database, using "IBM DB2 ODBC Driver". In my own client application, i
clicked connect (which then use this ODBC data source), it requires
more than 1 minute to make the connection. However, subsequent
select/query is nearly instant. It's just only the "connect" requires
significant time.
Any hints?
Thanks.
Shyam Peri - 28 Dec 2004 13:33 GMT
The following link might be of some help.
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/conn/t0005582.htm
Shyam Peri - 28 Dec 2004 13:36 GMT
The following link might be of some help.
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/conn/t0005582.htm