DB2 Reference Commands

I have to start saying, I just jump in DB2 world and this is my contribution to another beginners. The list of commands to start to use the DB2 engine.

Global Use

INSTHOME/sqllib/adm/db2licm -a filename register a DB2 license key by entering the
db2licm -l c
db2val validar instalacion
db2level donde se instalo
db2set -all db2 registry (e variables de entorno, i instancia y g global para todas las instancias)
db2set -lr lista todos los registros definibles
db2set = cambiar registro y luego reiniciar instancia

Instances

db2 catalog db research
db2 list db directory
db2icrt instance create
db2idrop instance drop
db2 get dbm cfg
db2 update dbm cfg using
db2 get instance

Databases

db2 get db cfg for
db2 update db cfg for using
db2 connect to
db2 terminate

db2 create db
db2 create tablespace mytbls1 managed by database using (file:'<path+file>’ ) bufferpool ibmdefaulttbp
db2 create table tabname(fields) in mytbls1

ALTER TABLESPACE RESOURCE
ADD (DEVICE ‘/dev/rhd9’ 10000,
DEVICE ‘/dev/rhd10’ 10000)

ALTER TABLESPACE DATA1 MANAGED BY AUTOMATIC STORAGE
ALTER TABLESPACE DATA1 REBALANCE

Miscellaneous

db2fs first step