DB2_V9.7 安装图解.doc

DB2 V9.7 安装图解定制安装localhost:/temp/server # lltotal 56drwxr-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 db2setupdrwxr-xr-x 15 bin bin 4096 Jun 1 2009 doc-r-xr-xr-x 1 bin bin 5181 Jun 1 2009 installFixPacklocalhost:/temp/server # ./db2setup &localhost:/temp/server # ps -ef|grep db2dasusr1 11150 1 0 22:10 ? 00:00:00 /home/dasusr1/das/adm/db2dasrrmroot 11669 1 0 22:10 ? 00:00:01 /opt/ibm/db2/V9.7/bin/db2fmcddasusr1 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.1db2inst1 24825 1 0 22:16 ? 00:00:01 /home/db2inst1/sqllib/bin/db2dasstm 1root 24970 5269 0 22:18 pts/1 00:00:00 su - db2inst1db2inst1 24971 24970 0 22:18 pts/1 00:00:00 -bashdb2inst1 25896 1 0 22:21 pts/1 00:00:00 /home/db2inst1/sqllib/bin/db2bp 24971A1001 5 Aroot 26843 8406 0 22:27 pts/2 00:00:00 grep db2localhost:/temp/server # localhost:/temp/server # su - db2inst1db2inst1localhost: db2start12/07/2009 22:28:07 0 0 SQL1063N DB2START processing was successful.SQL1063N DB2START processing was successful.db2inst1localhost: db2 connect to sample Database Connection Information Database server = DB2/LINUX 9.7.0 SQL authorization ID = DB2INST1 Local database alias = SAMPLEdb2inst1localhost: db2 backup db sample to /backup/Backup successful. The timestamp for this backup image is : 20091207222842db2inst1localhost:$ 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 resetDB20000I The SQL command completed successfully.$英语安装localhost:/temp/server # ps -ef|grep db2dasusr1 11150 1 0 22:10 ? 00:00:00 /home/dasusr1/das/adm/db2dasrrmroot 11669 1 0 22:10 ? 00:00:01 /opt/ibm/db2/V9.7/bin/db2fmcddasusr1 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.1db2inst1 24825 1 0 22:16 ? 00:00:01 /home/db2inst1/sqllib/bin/db2dasstm 1root 24970 5269 0 22:18 pts/1 00:00:00 su - db2inst1db2inst1 24971 24970 0 22:18 pts/1 00:00:00 -bashdb2inst1 25896 1 0 22:21 pts/1 00:00:00 /home/db2inst1/sqllib/bin/db2bp 24971A1001 5 Aroot 26843 8406 0 22:27 pts/2 00:00:00 grep db2localhost:/temp/server # localhost:/temp/server # su - db2inst1$ db2start12/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 ID NAME DEPT JOB YEARS SALARY COMM - - - - - - - 10 Sanders 20 Mgr 7 98357.50 - 20 Pernal 20 Sales 8 78171.25 612.45 8