首先1.打开cmd命令行,输入db2cmd命令,进入db2cmd命令提示行
2.数据库启动---db2start
3.数据库关闭---db2stop
4.数据库强制关闭---db2stop force
5.创建数据库----create datebase SSMS
6.数据库连接---db2 connect to SSMS user nc009 using bbbbbbb
其次7,执行SQL语句-----db2 select *from student
8.数据表导出-----export to a.txt of del select *from student
9.数据表导入-----import from b.txt of del insert into scores
10.数据表重组-----db2 reorg table student
11.数据表更新----db2 runstats on table student