Starting DB2

From SQLZOO
Revision as of 10:37, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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.

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense