If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Connect CLient Required

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-12, 04:43
irfanmaroof irfanmaroof is offline
Registered User
 
Join Date: Jan 2012
Posts: 53
DB2 Connect CLient Required

Hi

I need DB2 Connect Client download link.

and also guide which can best describe its features.

I want to use DB2 CONNECT CLIENT with db2 cli driver for my c++ Application to connect to remote Db2 Database server. I want to get rid from DB2 Client.Its hurdle that every database that i want to access in my C++ application using CLI driver need to add in DB2 Client and then using that DNS in C++ application.
Reply With Quote
  #2 (permalink)  
Old 02-07-12, 04:57
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
there is no connect client
only client and runtime client(no gui tools)
IBM DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows - United States
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 02-07-12, 05:13
irfanmaroof irfanmaroof is offline
Registered User
 
Join Date: Jan 2012
Posts: 53
Przytula will you go through this document and tell me how it is possible to connect DB2 Server using CLI driver without using data server client.

IBM DB2 9.7 for Linux, UNIX and Windows Information Center
Reply With Quote
  #4 (permalink)  
Old 02-07-12, 05:19
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
this type of appl always needs a db2 client as they do not provide their own comm mecanism as with java type4, which is the only that can run without db2 client
the others rely on predefined connections defined by db2 client
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #5 (permalink)  
Old 02-07-12, 05:30
irfanmaroof irfanmaroof is offline
Registered User
 
Join Date: Jan 2012
Posts: 53
This thing is really stupid for my application because I am trying to migrate whole data-warehousing from DB2 to teradata.

this way it is required to add all the database on remote server to local client.


What do you say ?
Reply With Quote
  #6 (permalink)  
Old 02-07-12, 05:42
irfanmaroof irfanmaroof is offline
Registered User
 
Join Date: Jan 2012
Posts: 53
One thing if i will use Db2 Runtime Client with my application.Still it would b required to add database on local client or not ?
Reply With Quote
  #7 (permalink)  
Old 02-07-12, 05:45
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
whenever client is installed you have to catalog the db server and remote db with commands :
Cataloging a TCP/IP node from a client using the CLP
and
CATALOG DATABASE
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #8 (permalink)  
Old 02-07-12, 05:58
irfanmaroof irfanmaroof is offline
Registered User
 
Join Date: Jan 2012
Posts: 53
thats alright but i want a way to bypass this client configuration thing on local system so that can connect directly to DB2 Server.
But DB2 Doesn't provide this.Am i right?
Reply With Quote
  #9 (permalink)  
Old 02-07-12, 07:18
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by irfanmaroof View Post
thats alright but i want a way to bypass this client configuration thing on local system so that can connect directly to DB2 Server.
But DB2 Doesn't provide this.Am i right?
You can do that with the DB2 jdbc universal driver and what DB2 calls it Type 4 Connection.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #10 (permalink)  
Old 02-07-12, 08:28
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by irfanmaroof View Post
thats alright but i want a way to bypass this client configuration thing on local system
You cannot bypass configuration, obviously, but you can automate it: Connecting to databases with the IBM Data Server Driver for ODBC and CLI - IBM DB2 9.7 for Linux, UNIX, and Windows
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On