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: Practice Data Science/Analysis with +100 Real Life Projects Your server today is: Dipsy