There are several commands that are important when using the DB2 RDBMS. For additional information about these and other database commands, see the DB2 documentation. These commands are used for the following operations:
-
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