Adding Node to DB2 instance

http://db2commerce.com/2011/04/14/how-to-catalog-a-db2-database/ 

Reference: http://db2commerce.com/2011/04/14/how-to-catalog-a-db2-database/

DB2 Update Manager Configuration Not working , says Invalide Node Type

[db2inst1@RHEL62x86ARL ~]$  db2 update dbm cfg using SVCENAME 50000
SQL5126N  An attempt was made to modify the database manager configuration
parameter "svcename" which is not valid for a node type of "2".
 

[db2inst1@RHEL62x86ARL ~]$ db2 ? SQL5126N


SQL5126N  An attempt was made to modify the database manager
      configuration parameter "<parm>" which is not valid for a node
      type of "<node-type-code>".

Explanation:

The user attempted to modify a database manager configuration parameter
which is invalid for the given node type. "<node-type-code"> is defined
as follows:

1        Database server with local and remote clients

2        Client

3        Database server with local clients

4        Partitioned Database Server with local and remote clients

5        Satellite Database Server with local clients

The requested change is not made.

User response:

Resubmit the request with a valid parameter for the given nodetype.

How to see if an instance of DB2 is already running in your machine

 

bash-3.00$ netstat  -an | grep 50000

bash-3.00$ ps   -eaf |  grep db2

bash-3.00$ ps   -eaf |  grep db2sysc 

Points to note:

1.db2 database owner is same as the instance owner created by using db2icrt command.

2.If the instance speficied is not identified then use following command:

   

/opt/IBM/db2/V9.7/instance/db2iupdt   < instance name> 

3.If the communication error occurs duing stop or start  or tcp/ip error.

check whether hostname is consistant in  /etc/hosts file, $DB2InstanceHome/sqllib/db2nodes.cfg
and with the hostname command.

Db2 Commandline to create a new DB2 database

http://dcon.com.br/db2-cli-install/

Install and Configure DB2 client locally to connect to remote db2 server

 

After DB2 client successfully installed, you should configure it to access the remote DB2 server using the Configuration Assistant or using the command line processor:

• Log on to the system with a valid DB2 user ID.
• Start the Configuration Assistant using the db2ca command.
• Search for servers.
• Test the connection using the Configuration Assistant.

or

• Catalog the TCP/IP node on the DB2 client:
•  
• db2 catalog tcpip node node_name remote hostname  server service_name
•  
• db2 catalog tcpip node nphantom remote 192.168.1.51  server 50000 
•  
• Catalog the database on the DB2 client:
•  
• db2 catalog database database_name as database_alias  at node node_name authentication auth_value
•  
• db2 catalog database sample as rsample  at node nphantom authentication server 
• 
  
• Test the client-server connection:
• db2 connect to rsample user v8inst
• db2 "select tabname from syscat.tables"
• db2 terminate