1 db2start
2 db2stop force 3 exit 4 db2set db2comm=tcpip 5 vi /etc/services 6 netstat -rn|more 7 netstat -an|more 8 netstat -an|grep 50000 9 db2 update dbm cfg using svcename 50000 10 netstat -an|grep 50000 11 db2start 12 vi /etc/services 13 netstat -an|grep 50000 14 ls 15 vi /etc/services 16 exit 17 db2 create database dzd using codeset GBK territory on Zh_cn; 18 db2 create database dzd using codeset GBK territory Zh_cn; 19 db2start 20 db2 create database dzd using codeset GBK territory Zh_cn; 21 df 22 cd / 23 ls -lrt 24 db2 connect to dzd; 25 db2 "create bufferpool dzd_buf size 1000 pagesize 32k"; 26 db2stop force 27 db2start; 28 db2 connect to dzd; 29 db2 "create tablespace dms_data pagesize 32k managed by database using(file'/dzddata/dms_data' 100000M) buffer_pool dzd_buf"; 30 db2 "create tablespace dms_data pagesize 32k managed by database using(file'/dzddata/dms_data' 100000M) bufferpool dzd_buf"; 31 ls -lrt 32 chmod 755 dzddata 33 chmod -R 755 dzddata 34 chmod -R 755 /dzddata 35 chmod -R 755 /db2data 36 db2 "create tablespace dms_data pagesize 32k managed by database using(file'/dzddata/dms_data' 100000M) bufferpool dzd_buf"; 37 chmod -R 777 /db2data 38 cd db2data 39 ls 40 cd .. 41 ls -lrt 42 cd db2data 43 ls 44 cd .. 45 ls 46 ls -lrt 47 db2 "create tablespace dms_data pagesize 32k managed by database using(file'/dzddata/dms_data' 100000M) bufferpool dzd_buf"; 48 db2 "create tablespace dms_data pagesize 32k managed by database using(file'/db2data/dms_data' 100000M) bufferpool dzd_buf"; 49 db2 "create tablespace dms_idx pagesize 32k managed by database using(file'/db2data/dms_idx' 10000M) bufferpool dzd_buf"; 50 db2 get dbm cfg 51 cd /etc 52 ls 53 cd rc.d 54 ls 55 more rc,local 56 more rc.local 57 ls 58 ls -lrt 59 db2start; 60 db2stop; 61 db2start; 62 db2restart; 63 db2stop; 64 db2stop force 65 db2start 66 db2 connect to dzd; 67 db2 get dbm cfg 68 db2 connect to dzd; 69 db2look -d dzd -e -o dzd.sql 70 more dzd.sql 71 db2 list tablespaces show detail 72 ls -lrt 73 more dzd.sql 74 cd / 75 ls 76 cd db2data 77 ls 78 db2 list tablespaces show detail 79 db2 list tablespaces for dzd 80 db2 list tablespaces 81 ls 82 db2 list tablespaces show detail 83 db2 "CREATE TEMPORARY TABLESPACE tmpspace PAGESIZE 32K MANAGED BY DATABASE USING(FILE ' db2data/tmpspace' 512M) EXTENTSIZE 1000 bufferpool " 84 db2 "CREATE TEMPORARY TABLESPACE tmpspace PAGESIZE 32K MANAGED BY DATABASE USING(FILE ' db2data/tmpspace' 512M) EXTENTSIZE 1000 bufferpool dzd_buf" 85 db2 "CREATE TEMPORARY TABLESPACE tmpspace PAGESIZE 32K MANAGED BY DATABASE USING(FILE ' db2data/tmpspace' 512M) EXTENTSIZE 32 bufferpool dzd_buf" 86 db2 list tablespaces show detail 87 ls -lrt 88 ls -la 89 ls -lrt 90 ls -la 91 db2stop 92 db2stop force 93 db2start 94 ls -lrt 95 ls -la 96 db2 list active databases 97 db2 list active database 98 db2 list active databases 99 db2 connect to dzd 100 db2 list active databases 101 ls -lrt 102 history