DB2_V9.7 安装图解
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
DB2 V9.7 安装图解定制安装
localhost:/temp/server # ll
total 56
drwxr-xr-x 6 bin bin 4096 Jun 1 2009 db2
-r-xr-xr-x 1 bin bin 5293 Jun 1 2009 db2_deinstall
-r-xr-xr-x 1 bin bin 5163 Jun 1 2009 db2_install
-r-xr-xr-x 1 bin bin 5127 Jun 1 2009 db2ls
-r-xr-xr-x 1 bin bin 5145 Jun 1 2009 db2prereqcheck
-r-xr-xr-x 1 bin bin 5145 Jun 1 2009 db2setup
drwxr-xr-x 15 bin bin 4096 Jun 1 2009 doc
-r-xr-xr-x 1 bin bin 5181 Jun 1 2009 installFixPack localhost:/temp/server # ./db2setup &
localhost:/temp/server # ps -ef|grep db2
dasusr1 11150 1 0 22:10 ? 00:00:00 /home/dasusr1/das/adm/db2dasrrm root 11669 1 0 22:10 ? 00:00:01 /opt/ibm/db2/V9.7/bin/db2fmcd dasusr1 11709 1 0 22:10 ? 00:00:00 /opt/ibm/db2/V9.7/das/bin/db2fmd -i dasusr1 -m /opt/ibm/db2/V9.7/das/lib/libdb2dasgcf.so.1
db2inst1 24825 1 0 22:16 ? 00:00:01 /home/db2inst1/sqllib/bin/db2dasstm 1
root 24970 5269 0 22:18 pts/1 00:00:00 su - db2inst1
db2inst1 24971 24970 0 22:18 pts/1 00:00:00 -bash
db2inst1 25896 1 0 22:21 pts/1 00:00:00 /home/db2inst1/sqllib/bin/db2bp 24971A1001 5 A
root 26843 8406 0 22:27 pts/2 00:00:00 grep db2
localhost:/temp/server #
localhost:/temp/server # su - db2inst1
db2inst1@localhost:~> db2start
12/07/2009 22:28:07 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful.
db2inst1@localhost:~> db2 connect to sample
Database Connection Information
Database server = DB2/LINUX 9.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
db2inst1@localhost:~> db2 backup db sample to /backup/
Backup successful. The timestamp for this backup image is : 20091207222842 db2inst1@localhost:~>
$ db2 "select * from staff where dept = 20"
ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ --------- ---------
10 Sanders 20 Mgr 7 98357.50 -
20 Pernal 20 Sales 8 78171.25 612.45
80 James 20 Clerk - 43504.60 128.20
190 Sneider 20 Clerk 8 34252.75 126.50
4 record(s) selected.
$ db2 connect reset
DB20000I The SQL command completed successfully.
$
英语安装
localhost:/temp/server # ps -ef|grep db2
dasusr1 11150 1 0 22:10 ? 00:00:00 /home/dasusr1/das/adm/db2dasrrm root 11669 1 0 22:10 ? 00:00:01 /opt/ibm/db2/V9.7/bin/db2fmcd dasusr1 11709 1 0 22:10 ? 00:00:00 /opt/ibm/db2/V9.7/das/bin/db2fmd -i dasusr1 -m /opt/ibm/db2/V9.7/das/lib/libdb2dasgcf.so.1
db2inst1 24825 1 0 22:16 ? 00:00:01 /home/db2inst1/sqllib/bin/db2dasstm 1
root 24970 5269 0 22:18 pts/1 00:00:00 su - db2inst1
db2inst1 24971 24970 0 22:18 pts/1 00:00:00 -bash
db2inst1 25896 1 0 22:21 pts/1 00:00:00 /home/db2inst1/sqllib/bin/db2bp 24971A1001 5 A
root 26843 8406 0 22:27 pts/2 00:00:00 grep db2
localhost:/temp/server #
localhost:/temp/server # su - db2inst1
$ db2start
12/07/2009 22:28:07 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful.
$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUX 9.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
$ db2 backup db sample to /backup/
Backup successful. The timestamp for this backup image is : 20091207222842
$
$ db2 "select * from staff where dept = 20"