db2 扩表空间 联合数据库

nidr

　　一、扩表空间
　　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";