一、创建数据库。在目录DB2下:
db2 create db stma
二、查看数据库。
db2 list db directory
三、复原数据库。
db2 restore db stmaold from d: to c: NEWLOGPATH c:/db2log/stma WITHOUT ROLLING FORWARD
四、连接数据库。
db2 connect to stma
五、删除数据库。
六、查看库中表。
db2 list tables
七、断开数据库连接。
db2 connect reset
AIX
AIX启动db2
一、远程连接命令:
telnet 19.168.1.14
二、用户名
root
三、登录
su - db2adming
五、roneold必须在d:根目录下。
db2 restore db roneold from d: to d: NEWLOGPATH c:/db2log/rone WITHOUT ROLLING FORWARD (rone)
db2 restore db cdbold from d: to d: NEWLOGPATH c:/db2log/datacdb WITHOUT ROLLING FORWARD (datacdb)
db2 restore db stmaold from d: to d: NEWLOGPATH c:/db2log/stma WITHOUT ROLLING FORWARD (stma)
db2 restore db roeeeold from d: to d: NEWLOGPATH c:/db2log/roeee WITHOUT ROLLING FORWARD (roeee)
db2 => quit
DB20000I QUIT 命令成功完成。
C:/Documents and Settings/d>db2stop force
SQL1064N DB2STOP 处理成功。
C:/Documents and Settings/d>db2start
SQL1063N DB2START 处理成功。
C:/Documents and Settings/d>db2 ?
一、常用命令
1. 建立数据库DB2_GCB
CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB
USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32
2. 连接数据库
connect to sample1 user db2admin using 8301206
3. 建立别名
create alias db2admin.tables for sysstat.tables;
CREATE ALIAS DB2ADMIN.VIEWS FOR SYSCAT.VIEWS
create alias db2admin.columns for syscat.columns;
create alias guest.columns for syscat.columns;
4. 建立表
create table zjt_tables as
(select * from tables) definition only;
create table zjt_views as
(select * from views) definition only;
5. 插入记录
insert into zjt_tables select * from tables;
insert into zjt_views select * from views;
6. 建立视图
create view V_zjt_tables as select tabschema,tabname from zjt_tables;
7. 建立触发器
CREATE TRIGGER zjt_tables_del
AFTER DELETE ON zjt_tables
REFERENCING OLD AS O
FOR EACH ROW MODE DB2SQL
Insert into zjt_tables1 values(substr(o.tabschema,1,8),substr(o.tabname,1,10))
8. 建立唯一性索引
CREATE UNIQUE INDEX I_ztables_tabname
ON zjt_tables(tabname);
9. 查看表
select tabname from tables
where tabname='ZJT_TABLES';
25. 显示当前活动数据库
list active databases
--导出数据,含表结构
EXPORT TO 'D:/RO_PERSONACCOUNT.ixf' OF IXF
SELECT * FROM "DB2ADMIN"."RO_PERSONACCOUNT";
--导入数据,并创建新表
IMPORT FROM 'D:/RO_PERSONACCOUNT.ixf' OF IXF
MODIFIED BY
COMPOUND=5
NOCHECKLENGTHS
COMMITCOUNT 1000
CREATE INTO "DB2ADMIN"."RO_PERSONACCOUNT"
IN "USERSPACE1";
设置数据库管理器的参数FEDERATED为Yes
db2 update dbm cfg using FEDERATED YES db2 force applications all db2 terminate db2stop db2start db2 get dbm cfg |