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
Ten Netstat-an|grep 50000
Db2start
Vi/etc/services
50000 Netstat-an|grep
+ ls
Vi/etc/services
Exit
DB2 CREATE DATABASE DZD using CodeSet GBK territory on ZH_CN;
DB2 CREATE DATABASE DZD using CodeSet GBK territory ZH_CN;
Db2start
DB2 CREATE DATABASE DZD using CodeSet GBK territory ZH_CN;
df
CD/
Ls-lrt
DB2 Connect to DZD;
DB2 "Create Bufferpool dzd_buf size pagesize 32k";
Db2stop Force
Db2start;
DB2 Connect to DZD;
DB2 "Create Tablespace dms_data pagesize 32k managed by database using (file '/dzddata/dms_data ' 100000M) bu Ffer_pool Dzd_buf ";
DB2 "Create Tablespace dms_data pagesize 32k managed by database using (file '/dzddata/dms_data ' 100000M) bu Fferpool Dzd_buf ";
Ls-lrt
chmod 755 Dzddata
Chmod-r 755 Dzddata
Chmod-r 755/dzddata
Chmod-r 755/db2data
DB2 "Create Tablespace dms_data pagesize 32k managed by database using (file '/dzddata/dms_data ' 100000M) bu Fferpool Dzd_buf ";
Panax Notoginseng chmod-r 777/db2data
CD Db2data
All-in LS
CD.
Ls-lrt
Db2data CD
ls
CD:
ls
Ls-lrt
DB2 "Create Tablespace dms_data pagesize 32k managed by database using (file '/dzddata/dms_data ' 100000M) bu Fferpool Dzd_buf ";
DB2 "Create Tablespace dms_data pagesize 32k managed by database using (file '/db2data/dms_data ' 100000M) bu Fferpool Dzd_buf ";
DB2 "Create Tablespace dms_idx pagesize 32k managed by database using (file '/db2data/dms_idx ' 10000M) buffe Rpool Dzd_buf ";
DB2 get dbm CFG
Wuyi Cd/etc
ls
RC.D CD
Si ls
More rc,local
More rc.local
The LS
Ls-lrt
Db2start;
Db2stop;
Db2start;
Db2restart;
Db2stop;
Db2stop Force
Db2start
DB2 Connect to DZD;
DB2 get dbm CFG
DB2 Connect to DZD;
db2look-d dzd-e-O dzd.sql
More Dzd.sql
DB2 List tablespaces Show Detail
Ls-lrt
More Dzd.sql
CD/
The LS
CD Db2data
The LS
DB2 List tablespaces Show Detail
DB2 list tablespaces for DZD
DB2 List tablespaces
Bayi ls
DB2 List tablespaces Show Detail
DB2 "CREATE temporary tablespace tmpspace PAGESIZE 32K MANAGED by DATABASE USING (FILE ' db2data/tmpspace ' 512M) exten Tsize Bufferpool "
DB2 "CREATE temporary tablespace tmpspace PAGESIZE 32K MANAGED by DATABASE USING (FILE ' db2data/tmpspace ' 512M) exten Tsize Bufferpool Dzd_buf "
DB2 "CREATE temporary tablespace tmpspace PAGESIZE 32K MANAGED by DATABASE USING (FILE ' db2data/tmpspace ' 512M) exten Tsize Bufferpool Dzd_buf "
DB2 List tablespaces Show Detail
Ls-lrt
Ls-la
Ls-lrt
Ls-la
Db2stop
Db2stop Force
Db2start
94 LS-LRT
Ls-la
DB2 List Active databases
DB2 List Active Database
98 DB2 List Active databases
DB2 Connect to DZD
DB2 List Active databases
101 LS-LRT
102 History
Linux establishes DB2 database common commands