Db2 Getting Started

Db2 Getting Started

§Instance
db2icrt
db2idrop
db2start
db2stop

§Env variables
db2profile (db2cshrc for c shell)
DB2INSTANCE
•List all available instances
db2ilist
•db2 profile registry
-global registry
-instance registry
•View all registry
db2set -lr
•Set global env
db2set DB2INSTPROF= -g
•Set instance env
db2set DB2INSTPROF= -i MyInst
•dbm cfg (database mgr cfg file)
db2 get dbm cfg
•update dbm cfg
db2 update dbm cfg using
•db cfg
db2 qet db cfg for
db2 update db cfg for using

Connect
§System db directory
Contains all dbs you can connect to from your db2 system. Stored at instance level.
•db2 list db directory
Local: indirect
Remote: remote
•Add db directory entry
db2 catalog db as at node
•Local db directory
Contains info about local dbs.
db2 list db directory on •Node directory
Contains all connectivity info for remote databases. Supports only tcpip in ver8.
db2 list node directory
db2 catalog tcpip node mynode remote 9.26.138.35 server 60000
•DCS directory
Contains connectivity info for host dbs on zSeries or iSeries machines.
db2 list dcs directory
db2 catalog dcs db as db1g

§Databases
create database

§Tablespace
•Catalog (SYSCATSPACE)
•Temp (TEMPSPACE1)
•User space (USERSPACE1)

§Example
db2ilist
db2 get instance
set DB2INSTANCE=MyInstance
db2 list db directory
db2 create database temporal
db2 connect to mydb2 user peenv7
db2 list tables
db2 list tablespaces
// backup instance
db2 qet dbm cfq > dbmcfq.bak
db2set -all > db2set.bak
db2 list db directory > systemdbdir.bak
db2 list node directory > nodedir.bak
db2 list dcs directory > dcs.bak
//end backup
db2 drop database temporal

§CLP
•Verify installation
select count(*) from syscat.tables
select count(*) from sysibm.tables
select count(*) from sysibm.sysdummy1
describe table syscat.tables
•Help
db2 ? sql0100 | more
•Scripting
select text from syscat.views
select text,tabname from syscat.checks
select text from syscat.procedures
select text from syscat.triggers

Filed under: db2 | |No Comments