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.
$
英语安装