1.DB2实例和数据库的目录结构:
.1> [root@demo instance]# ./db2icrt -u fenced test
DBI1070I Program db2icrt completed successfully.
[root@demo instance]# ./db2ilist
db2inst1
test
实例test创建成功后,在实例home目录下生成了一个sqllib文件夹/home/test/sqllib,里面是一些配置文件以及软链接
到软件安装目录的文件:
[test@demo sqllib]$ ll
total 92
drwxr-xr-x 2 test test 4096 Dec 28 16:11 adm
lrwxrwxrwx 1 root test 22 Dec 28 16:11 adsm -> /opt/ibm/db2/V9.7/adsm
drwxr-x--- 2 test test 4096 Dec 28 16:11 backup
lrwxrwxrwx 1 root test 21 Dec 28 16:11 bin -> /opt/ibm/db2/V9.7/bin
drwxrwsr-t 2 test test 4096 Dec 28 16:13 cfg
lrwxrwxrwx 1 root test 22 Dec 28 16:11 conv -> /opt/ibm/db2/V9.7/conv
-rwxr-xr-x 1 test test 10575 Dec 28 16:11 db2cshrc
drwxrwsrwt 4 test test 4096 Dec 28 16:18 db2dump ------->db2diag.log存放目录
-rwxr-xr-x 1 test test 6650 Dec 28 16:11 db2profile
-rw-rw-r-- 1 test test 16384 Dec 28 16:13 db2systm ---->实例配置文件get dbmcfg读取
lrwxrwxrwx 1 root test 21 Dec 28 16:11 doc -> /opt/ibm/db2/V9.7/doc
drwxrwsr-t 4 test test 4096 Dec 28 16:11 function
lrwxrwxrwx 1 root test 23 Dec 28 16:11 gskit -> /opt/ibm/db2/V9.7/gskit
drwx------ 3 test test 4096 Dec 28 16:13 hmonCache
lrwxrwxrwx 1 root test 22 Dec 28 16:11 java -> /opt/ibm/db2/V9.7/java
lrwxrwxrwx 1 root test 5 Dec 28 16:11 lib -> lib32
lrwxrwxrwx 1 root test 23 Dec 28 16:11 lib32 -> /opt/ibm/db2/V9.7/lib32
drwxrwsr-t 2 test test 4096 Dec 28 16:11 log
lrwxrwxrwx 1 root test 22 Dec 28 16:11 misc -> /opt/ibm/db2/V9.7/misc
lrwxrwxrwx 1 root test 25 Dec 28 16:11 samples -> /opt/ibm/db2/V9.7/samples
drwxr-xr-x 3 test test 4096 Dec 28 16:11 security
drwxr-xr-x 3 test test 4096 Dec 28 16:11 security32
drwxrwxr-x 2 test test 4096 Dec 28 16:12 sqldbdir -------->系统库目录
drwxrwsrwx 2 test test 4096 Dec 28 16:11 tmp
lrwxrwxrwx 1 root test 23 Dec 28 16:11 tools -> /opt/ibm/db2/V9.7/tools
drwxrwxrwx 2 test test 4096 Dec