DB2 client instance start

heartwork93 · #1 (**permalink**) 04-15-09, 05:01

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,

przytula_guy · #2 (**permalink**) 04-15-09, 05:43

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

heartwork93 · #3 (**permalink**) 04-15-09, 09:38

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,

przytula_guy · #4 (**permalink**) 04-15-09, 11:35

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

n_i · #5 (**permalink**) 04-15-09, 11:50

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.