db2 基本命令和变量

db2icrt <instance name>
db2idrop <instance name>
其中i = instance 实例， 需root权限

实例用户 或一般用户的命令来自哪里？
如果没有设置的普通用户： 只用命令 db2ls == db2 list( /usr/local/bin/db2ls )

vi .bashrc
...
# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
fi
...

环境变量： 操作系统级别的变量

注册变量:
　　1 Global-Level variable
　　2 Instance-Level variable

[i] DB2COMM=TCPIP
[g] DB2FCMCOMM=TCPIP4
[g] DB2SYSTEM=node22.km.hm
[g] DB2ADMINSERVER=dasuser1

Configuration parameters

db2 get dbm cfg (instance)

db2 get db cfg (database)

System database directory 系统编目

# db2 list db directory

sqldbdir]$ cat /home/db2inst1/sqllib/sqldbdir/sqldbdir

DB2 DIRECTORY

��
NAV     NAV     0�/data/db2/db2inst1ib                              ��SQLDBD02
UTF-8O�
USUTF-8O�
� #"7�
SAMPLE  SAMPLE  0�/data/db2/db2inst1ib                              )��SQLDBD020

UTF-8
USUTF-8
� $XBv8@v�ؒ$R�[DB2Q

Local database directory

# db2 list db directory on /data/db2

sqldbdir]$ cat /data/db2/db2inst1/NODE0000/sqldbdir/sqldbdir

DB2 DIRECTORY
��NAV     NAV     2SQL00001�/data/db2/db2inst1                              SQLDBD02
UTF-8O�
USUTF-8O�
� #"7�

Node directory

# db2 list node directory

$ cat /home/db2inst1/sqllib/sqlnodir/sqlnodir

NODE DIRECTORYKWINGMEILocal workstationdasusr1KWINGMEIUNODE21192.168.121.2150000UNODE22192.168.121.2250000UNODE22_2192.168.121.2250020U  

example:

export DB2INSTANCE=db2inst1 

db2 get instance = db2inst1

export export DB2INSTANCE= noexist

db2 get instance = SQL10007N Message "-1390" could not be retrieved.  Reason code: "3".

备份：

db2 get dbm cfg > dbmcfg.bk
db2set -all > db2set.bk
db2 list db directory > systemdbdir.bk
db2 list node directory > nodedir.bk
db2 list dcs directory > dcsdir.bk