Starting DB2

From SQLZoo
Jump to navigation Jump to search
Name of the client db2 - also known as the Command Line Processor (CLP)
Typical command line to start the client
. /home/db2inst1/sqllib/db2profile
connect to scott


This is the "instance" - a unix user account. The super user who owns all the files and processes.


scott is a unix account name and the name of the database. The instance user can issue create database scott (this takes nearly 3 minutes to complete on my superfast machine.) The database scott seems to be owned by the unix user scott without any further action.

no passwords

The system seems to rely on unix user accounts.

Useful commands
list tables
describe table cia

No semi colons.