db2 command http://publib.boulder.ibm.com/tividd/td/ITCM/GC23-4702-01/en_US/HTML/CM_PI185.htm#wq576

Start a DB2 interactive session

To start an interactive session, enter the follow command:

db2

Catalog the DB2 server node

To catalog the DB2 server node, enter the following command:

db2 catalog tcpip node db2node remote hostname server service_name

where db2node is the name of the system where the DB2 client is installed (which must be unique in your node directory list), hostname is the fully qualified name of the system where the DB2 server is installed, and service_name is the connection port name as defined in the services file.

Catalog remote DB2 databases

To catalog a remote database, enter the following command:

db2 catalog database db_name as alias_name at node db2node 

where db_name is the name of the remote database, alias_name is the name of the client instance, and db2node is the name of the system where the DB2 client is installed.

Connect to the DB2 server

To connect to a DB2 server, enter the following command:

db2 connect to database user name using password

where database is the name or alias of the database in the system database directory, name is the user name of the instance owner of the database, and password is the password for the previous user.

Run scripts

To run a script, enter the following command:

db2 -f script_name -o -t -z log_name

where script_name is the name of the script and log_name is the name of the log file.

End a DB2 session

To log out of an interactive session, enter the following command:

quit