db2 扩表空间 联合数据库
一、扩表空间load from /db2_backup/info.ixf of ixf terminate into info nonrecoverable
db2 connect to bpfdb user db2admin using db2admin
db2 list tablespaces show detail
db2 list tablespace containers for 9 show detail
DB2Server:#db2 list tablespace containers for 9 show detail
Tablespace Containers for Tablespace 9
Container ID = 0
Name = /dev/rdb2temp1lv
Type = Disk
Total pages = 262144
Useable pages = 262112
Accessible = Yes
Container ID = 1
Name = /dev/rdb2temp2lv
Type = Disk
Total pages = 262144
Useable pages = 262112
Accessible = Yes
显示TEMPSPACE表空间有两个容器/dev/rdb2temp1lv和/dev/rdb2temp2lv
lsvg db2vg ,得到PP SIZE: 256 megabyte(s),因此1G空间需要4个PP。
extendlv db2temp1lv 4
extendlv db2temp2lv 4
alter tablespace tempspace extend(device '/dev/rdb2temp1lv' 1G,device '/dev/rdb2temp2lv' 1G)
二、 联合数据库
1、连接业务数据库，打开数据库管理器的联合(federated)属性
db2
db2 =>update dbm cfg using federated YES
db2 =>db2stop force
db2 =>db2start
2.编目数据库
db2 =>catalog tcpip node dbnode remote ip server 50000
db2 =>catalog db platform as platform at node dbnode
3.登陆业务数据库
db2 =>connect to platform user db2admin using 123
4.建立db2(drda)包装器
db2 =>create wrapper drda
5.建立远程服务器(svr_dc)指向远程的数据源(数据中心DB)，同时指定远程的验证信息(user:db2admin pwd:123)，登陆和密码根据实际修改
db2 =>create server svr_y type db2/aix version 8.2 wrapper drda authorization "db2admin" password "123" options(dbname 'platform')
6.建立本地用户至远程登陆的映射，登陆和密码根据实际修改
db2 =>create user mapping for "xxx" server svr_y options (remote_authid 'db2admin' , remote_password '123')
CREATE NICKNAME "XXX"."T_USER_LNK" FOR "SVR_Y"."DB2ADMIN"."T_USER";
页:
[1]