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
DB2COMM=TCPIP
DB2FCMCOMM=TCPIP4
DB2SYSTEM=node22.km.hm
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�
SAMPLESAMPLE0�/data/db2/db2inst1ib )��SQLDBD020 UTF-8USUTF-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
页:
[1]