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
db2
connect to scott

db2inst1

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

scott

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
?
Beware!

No semi colons.

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects