Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    24

    Unanswered: DB2 client instance start

    After the installation of a DB2 client (inside some 3rd party installer) - this did not finish quite OK.
    Here is how the response file looks like:

    HTML Code:
    .............
    *  Product Installation 
    LIC_AGREEMENT       = ACCEPT
    FILE = /usr/db2
    PROD       = CLIENT
    INSTALL_TYPE       = COMPACT
    * ----------------------------------------------
    *  Instance properties           
    * ----------------------------------------------
    INSTANCE       = db2inst1
    db2inst1.TYPE       = client
    *  Instance-owning user
    db2inst1.NAME       = db2inst1
    db2inst1.GROUP_NAME       = .........
    db2inst1.HOME_DIRECTORY       = /home/db2inst1
    db2inst1.PASSWORD       = ........
    ENCRYPTED       = db2inst1
    db2inst1.AUTOSTART       = YES
    db2inst1.AUTHENTICATION       = SERVER
    Also a part from db2install.history file:

    HTML Code:
    Operating system information: AIX 5.3
    WARNING:Notification SMTP server has not been specified. Notifications cannot be sent to contacts in your contact list until this is specified.
    
    Product to install:                        DB2 Client
    Installation type:                         Compact
    Previously Installed Components:        
    Selected Components:                    
        Product Messages - English             
        Base client support                    
        SQL procedures                         
        Product Signature for DB2 Client       
    Languages:                              
        English                                
            All Products                       
    Target directory:                          /usr/db2
    ..........                                   
    New instances:                          
        Instance name:                         db2inst1
            Authentication:                    SERVER
            Start instance on reboot:          Yes
            Instance user information:         
                User name:                     db2inst1
                Group name:                    ..........
                Home directory:                /home/db2inst1
                                            
                                                                               
    
    Enabling Asynchronous I/O:.......Success
    Checking license agreement acceptance:.......Success
    Command to be run: "/bin/gunzip -c /install/tmp_db_client/client/disk1/db2/aix/FILES/DB2_PRODUCT_MESSAGES_EN_9.1.0.5_aix_ppc.tar.gz | (cd /usr/db2; /bin/tar xvf -)".
    Command to be run: "/bin/gunzip -c /install/tmp_db_client/client/disk1/db2/aix/FILES/BASE_CLIENT_9.1.0.5_aix_ppc.tar.gz | (cd /usr/db2; /bin/tar xvf -)".
    Command to be run: "/bin/gunzip -c /install/tmp_db_client/client/disk1/db2/aix/FILES/SQL_PROCEDURES_9.1.0.5_aix_ppc.tar.gz | (cd /usr/db2; /bin/tar xvf -)".
    Command to be run: "/bin/gunzip -c /install/tmp_db_client/client/disk1/db2/aix/FILES/CLIENT_PRODUCT_SIGNATURE_9.1.0.5_aix_ppc.tar.gz | (cd /usr/db2; /bin/tar xvf -)".
    Installing DB2 file sets:.......Success
    Setting DB2 library path:.......Success
    Executing control tasks:.......Success
    Updating global registry:.......Success
    Updating the db2ls link:.......Success
    Setting default global profile registry variables:.......Success
    Initializing instance list:.......Success
    Command to be run: "cd /usr/db2/;/usr/db2/instance/db2icrt -a SERVER -d  -s client db2inst1".
    The instance "db2inst1" has been created successfully.
    
    The value "AUTHENTICATION=SERVER" was set in the DBM CFG file for the "db2inst1" instance.
    
    [B]ERROR:ksh: /home/db2inst1/sqllib/adm/db2start:  not found.[/B]
    
    [B]ERROR:An error occurred while trying to start the "db2cl" instance. The return code is "127" and the SQL Message is:   "PROCESS_ERROR"[/B]
    
    Configuring DB2 instances:.......Success
    Updating global profile registry:.......Success
    
    Post Install Rec.......
    This should be a DB2 Client instance (part of some WebSphere MQ Broker app.) that has to connect to some DB2 server (already successfully installed).
    As I understand it is normal that DB2 Client does not have db2start / db2stop - then how is this managed?
    Maybe I have to use some other packages for the installation to complete successfully?
    Next step should be to configure DB2 client to connect to the server - maybe someone can guide me for this process... steps to be done for both client and server... it might sound like a newbie question
    At this moment I will try to clean everything and retry for the 3rd time again.

    Thanks a lot,

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    there is no db2start for a client instance
    you should :
    install the client code with root to /opt/ibm/db2/V9.5 or any other directory
    when done
    cd to this install directory : instance
    db2icrt should be used with option client instance for the user
    db2icrt - Create Instance
    in this user sqllib and all directories will be created with needed links
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Feb 2009
    Posts
    24
    Client instance successfully created - this also means the client instance is up? (I am still a bit confused) - so there is no need to start/stop this instance - this is done by server right?!
    In order to establish client-server connection between them I have to:
    1. Configure DB2 server for TCP/IP / service name + port
    2. Catalog DB2 client to connect to this server
    and this is enough (after my comprehnesion after reading docs)
    Please correct me if I am wrong.

    Thank you,

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    at the client (no start)
    db2 catalog tcpip node xxx remote yyy server zzz
    yyy=ipaddress/hostname
    db2 catalog db ddd at node xxx
    zzz=port of server instance
    db2 connect to ddd user uuu using pppp
    that is all
    see infocenter IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    for all details
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by heartwork93
    Client instance successfully created - this also means the client instance is up? (I am still a bit confused) - so there is no need to start/stop this instance - this is done by server right?!
    Client instance is just a bunch of environment and configuration settings (e.g. database catalog); there is nothing to start or stop.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Feb 2009
    Posts
    24
    Now everything is clear for me.
    Everything worked just fine.

    Thanks a lot guys,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •