Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


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 vs DB2 Data Server Client

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-14-11, 17:31
Gideon22 Gideon22 is offline
Registered User
  
Join Date: Jun 2011
Posts: 39
DB2 Connect vs DB2 Data Server Client
I need a DB2 Client (9.7)

From what I have read it appears I could use either DB2 Data Server Client or DB2 Connect

What is the difference between these 2 ?

What is DB2 Data Server Client Runtime ?

Thanks
Reply With Quote
  #2 (permalink)  
Old 07-14-11, 17:52
Marcus_A Marcus_A is offline
Registered User
  
Join Date: May 2003
Location: USA
Posts: 5,196
DB2 Connect is necessary for connecting to DB2 z/OS or DB2 iSeries from a DB2 LUW client. This is fee for license product.

Data server client includes some tools like Control Center and Configuration assistant, whereas run time client is only the client files with no GUI interfaces. These are completely free.
__________________
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
  #3 (permalink)  
Old 07-14-11, 18:00
Gideon22 Gideon22 is offline
Registered User
  
Join Date: Jun 2011
Posts: 39
Would DB@ Data Server Client be the 'normal' way to remotely connect to a Linux server from another Linux Server ?
Reply With Quote
  #4 (permalink)  
Old 07-14-11, 18:05
Marcus_A Marcus_A is offline
Registered User
  
Join Date: May 2003
Location: USA
Posts: 5,196
The data server clients include both type 2 and type 4 (universal jdbc jar file) client files, so yes, one of those would be the way to connect to DB2 LUW from a Linux Client depending on how you need to connect. If your Linux "client" is also a DB2 server, it will automatically include a DB2 client (for jdbc, the jar files are in $HOME/sqllib/java where $HOME is the instance owner home).
__________________
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
  #5 (permalink)  
Old 07-14-11, 18:10
Gideon22 Gideon22 is offline
Registered User
  
Join Date: Jun 2011
Posts: 39
Can the DB2 Data Server Client communicate through ODBC as well as JDBC?
Reply With Quote
  #6 (permalink)  
Old 07-14-11, 18:13
Marcus_A Marcus_A is offline
Registered User
  
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by Gideon22 View Post
Can the DB2 Data Server Client communicate through ODBC as well as JDBC?
There is a recent thread on using ODBC on a Linux machine to connect to DB2. See if you can find it.
__________________
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
  #7 (permalink)  
Old 07-14-11, 20:10
Gideon22 Gideon22 is offline
Registered User
  
Join Date: Jun 2011
Posts: 39
db2 install error
I just attempted to install DB2 ESE 9.7 on a Linux machine

I ran ./db2setup and choose the typical options, and then let it run, below is my selections summary:

Code:
Product to install:                        DB2 Enterprise Server Edition 
Installation type:                         Typical 
                                        
Previously Installed Components:        
Selected Components:                    
    Base client support                    
    Java support                           
    SQL procedures                         
    Base server support                    
    IBM Software Development Kit (SDK) for Java(TM)    
    Connect support                        
    Communication support - TCP/IP         
    Replication tools                      
    Control Center                         
    DB2 data source support                
    DB2 LDAP support                       
    DB2 Instance Setup wizard              
    DB2 Update Service                     
    First Steps                            
    Sample database source                 
                                        
Languages:                              
    English                                
        All Products                       
                                        
Target directory:                          /opt/ibm/db2/V9.7
                                        
Space required:                            894 MB
Install SA MP:                             Yes 
                                        
New instances:                          
    Instance name:                         db2inst1
        Start instance on reboot:          Yes 
        Instance user information:         
            User name:                     db2inst1
            Group name:                    db2iadm1
            Home directory:                /home/db2inst1
        Fenced user information:           
            User name:                     db2fenc1
            Group name:                    db2fadm1
            Home directory:                /home/db2fenc1
                                        
DB2 Administration server:              
    Instance user information:             
        User name:                         dasusr1
        Group name:                        dasadm1
        Home directory:                    /home/dasusr1
                                        
                                        
                                        
Response file name:                        /root/db2ese.rsp
When I came back to my screen, the install GUI was not there, and I did not have a complete installation. I could not log into db2inst1.

I could log into dasusr1, I logged in, the das subdirectory was there, but the db2admin was not started

Below is my response file:


Code:
inst1.NAME       = db2inst1
inst1.GROUP_NAME       = db2iadm1
inst1.HOME_DIRECTORY       = /home/db2inst1
inst1.PASSWORD       = 175418540193694175665374221541723441635522826243368553443304525264932113512844409525293
ENCRYPTED       = inst1.PASSWORD
inst1.AUTOSTART       = YES
inst1.CONFIGURE_TEXT_SEARCH       = NO
*  Fenced user
inst1.FENCED_USERNAME       = db2fenc1
inst1.FENCED_GROUP_NAME       = db2fadm1
inst1.FENCED_HOME_DIRECTORY       = /home/db2fenc1
inst1.FENCED_PASSWORD       = 254129234592675241808264723951655545295471455015231624305461336522160442233262143235468
ENCRYPTED       = inst1.FENCED_PASSWORD
*-----------------------------------------------
*  Installed Languages
*-----------------------------------------------
LANG       = EN
*-----------------------------------------------
*  SA MP Base Component
*-----------------------------------------------
INSTALL_TSAMP = YES
What should I do to fix this.

Should I delete all files from the /opt/ibm/db2 and install again ?

Thanks
Reply With Quote
  #8 (permalink)  
Old 07-14-11, 20:12
Gideon22 Gideon22 is offline
Registered User
  
Join Date: Jun 2011
Posts: 39
I am sorry for the last reply, I meant to start a new thread
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.