前言:搞了10年的Oracle,最近开始学习DB2,从牛书开始,将我学习过程中的测试命令及过程和大家共享,遇到的问题也如实写在上面,希望和大家一起学习!
大家也可以参考我的BLOG:
http://www.db2china.net/home/space.php?uid=45420&do=blog,欢迎大家指正,谢谢!
第一篇:
1-DB2在Linux下的命令行安装过程1、增加用户db2inst1--DB2软件管理,dasusr1--das所有者
[root@localhost ~]# useradd -d /home/db2inst1 db2inst1
[root@localhost ~]# useradd -d /home/dasusr1 dasusr1
[root@localhost ~]# passwd db2inst1
Changing password for user db2inst1.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@localhost ~]# passwd dasusr1
Changing password for user dasusr1.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
2、切换到db2inst1
[root@localhost ~]# su - db2inst1
ls [db2inst1@localhost ~]$ ls -l
total 624360
-rw-rw-r-- 1 db2inst1 db2inst1 30413 Jan 7 02:02 aa.snp
drwxrwxr-x 3 db2inst1 db2inst1 4096 Jan 16 20:52 arch
-rw-rw-r-- 1 db2inst1 db2inst1 8681 Jan 9 21:27 cfg
-rw-r--r-- 1 root root 512 Jan 12 01:43 comnparam2.del
-rw-rw-r-- 1 db2inst1 db2inst1 1070 Jan 12 22:21 DART.INF
drwxrwxr-x 3 db2inst1 db2inst1 4096 Jan 17 01:10 db2inst1
-rw-rw-r-- 1 db2inst1 db2inst1 8681 Jan 7 01:37 db2inst1.cfg
drwxrwxr-x 4 db2inst1 db2inst1 4096 Jan 16 23:20 dbbak
drwxr-xr-x 2 db2inst1 db2inst1 4096 Jan 4 17:26 Desktop
drwxrwxr-x 6 db2inst1 db2inst1 4096 Jan 17 01:28 mydb
-rw-rw-r-- 1 db2inst1 db2inst1 30414 Jan 7 01:53 mydb.snp
-rw-r----- 1 db2inst1 db2inst1 0 Jan 12 01:49 param3.dmp.load.000
drwxr-xr-x 4 root root 4096 Apr 26 2011 server
drwxrwsr-t 22 db2inst1 db2inst1 4096 Jan 8 04:28 sqllib
-rw-rw-r-- 1 db2inst1 db2inst1 3 Jan 10 19:09 test.del
-rw-r--r-- 1 root root 638564957 Jan 1 18:28 v9.7_linuxia32_server.tar.gz
[db2inst1@localhost ~]$ tar xzvf v9.7_linuxia32_server.tar.gz
3、解压安装文件并启动安装程序
[db2inst1@localhost ~]$ cd server/
db2/ db2_deinstall db2ls db2setup installFixPack
db2ckupgrade db2_install db2prereqcheck doc/
[db2inst1@localhost ~]$ cd server/
db2/ db2_deinstall db2ls db2setup installFixPack
db2ckupgrade db2_install db2prereqcheck doc/
[db2inst1@localhost ~]$ cd server/
[db2inst1@localhost server]$ ./db2_install
DBI1244I Directory for non-root installation of DB2 - /home/db2inst1/sqllib
Specify one of the following keywords to install DB2 products.
AESE
ESE
CONSV
WSE
EXP
PE
CLIENT
RTCL
Enter "help" to redisplay product names.
Enter "quit" to exit.
***********************************************************
ESE
4、安装过程
......
Task #9 end
Task #10 start
Description: SQL procedures
Estimated time 3 second(s)
Task #10 end
......
For more information see the DB2 installation log at "/tmp/db2_install.log.6613".
[root@localhost server]#
[root@localhost server]#
[root@localhost server]#
[root@localhost server]#
[root@localhost server]# more /tmp/db2_install.log.6613
DB2 Setup log file started at: Sun Jan 1 18:31:27 2012 PST
============================================================
Operating system information: Linux 2.6.18-8.el5.#1 SMP Fri Jan 26 14:15:21 EST 2007 i686
WARNING: Notification SMTP server has not been specified. Notifications cannot
be sent to contacts in your contact list until this is specified. For more
information see the DB2 administration documentation.
Product to install: DB2 Enterprise Server Edition
Previously Installed Components:
Selected Components:
Base client support
Java support
SQL procedures
Base server support
IBM Software Development Kit (SDK) for Java(TM)
Connect support
Communication support - TCP/IP
Replication tools
Control Center
DB2 data source support
DB2 LDAP support
DB2 Instance Setup wizard
Spatial Extender client
Base application development tools
DB2 Update Service
First Steps
Sample database source
DB2 Text Search
Informix data source support
Languages:
Target directory: /home/ibm/db2/V9.7
Space required: 863 MB
Install SA MP: No
Checking license agreement acceptance :.......Success
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/BASE_CLIENT_R_9.7.0.4_linuxia32_i386
.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/DB2_PRODUCT_MESSAGES_EN_9.7.0.4_linu
xia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/BASE_CLIENT_9.7.0.4_linuxia32_i386.t
ar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/JAVA_RUNTIME_SUPPORT_9.7.0.4_linuxia
32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/DB2_JAVA_HELP_EN_9.7.0.4_linuxia32_i
386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/BASE_DB2_ENGINE_R_9.7.0.4_linuxia32_
i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/GSK_9.7.0.4_linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/JAVA_SUPPORT_9.7.0.4_linuxia32_i386.
tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/SQL_PROCEDURES_9.7.0.4_linuxia32_i38
6.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/ICU_SUP_9.7.0.4_linuxia32_i386.tar.g
z)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/JAVA_COMMON_FILES_9.7.0.4_linuxia32_
i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/BASE_DB2_ENGINE_9.7.0.4_linuxia32_i3
86.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/JDK_9.7.0.4_linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/DB2_CONTROL_CENTER_HELP_EN_9.7.0.4_l
inuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/CONNECT_SUPPORT_9.7.0.4_linuxia32_i3
86.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/COMMUNICATION_SUPPORT_TCPIP_9.7.0.4_
linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/DATABASE_PARTITIONING_SUPPORT_9.7.0.
4_linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/EDB_9.7.0.4_linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/REPL_CLIENT_9.7.0.4_linuxia32_i386.t
ar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/RELATIONAL_WRAPPERS_COMMON_9.7.0.4_l
inuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/CONTROL_CENTER_9.7.0.4_linuxia32_i38
6.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/CLPPLUS_9.7.0.4_linuxia32_i386.tar.g
z)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/DB2_DATA_SOURCE_SUPPORT_9.7.0.4_linu
xia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/LDAP_EXPLOITATION_9.7.0.4_linuxia32_
i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/INSTANCE_SETUP_SUPPORT_9.7.0.4_linux
ia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/SPATIAL_EXTENDER_CLIENT_SUPPORT_9.7.
0.4_linuxia32_i386.tar.gz)".
Command to be run: "(cd /home/ibm/db2/V9.7; /bin/tar xzvf /home/db2inst1/server/db2/linux/FILES/APPLICATION_DEVELOPMENT_TOOLS_9.7.0.
4_linuxia32_i386.tar.gz)".
[root@localhost server]# ps -ef|grep db2
root 30710 1 0 18:44 ? 00:00:00 /home/ibm/db2/V9.7/bin/db2fmcd
root 30780 6194 0 18:45 pts/1 00:00:00 grep db2
收起