informix数据库扩容操作步骤

一、 目前现网SMP数据库情况

1、informix数据库采用双机（RP5470）+磁盘阵列存储，保证informix始终在主机上运行，并以独占方式控制管理阵列上的数据库空间。

目的： informix数据库扩容，需要新建裸设备给数据库当chunk使用。目前50G的磁盘阵列，还剩余约28G，另外未分配还可用的107GB，划分若干个chunk，每个chunk大小为2G。

2、以下是SCP1主机当前的数据空间情况：

目前SMP数据库用户数据容量为12G

$ onstat -d

[smp@SCP1] /home/smp $onstat -d

Informix Dynamic Server Version 7.31.FD6 -- On-Line -- Up 2 days 11:54:31 -- 924392 Kbytes

Dbspaces

address number flags fchunk nchunks flags owner name

c000000037a541c8 1 1 1 1 N informix rootdbs

c000000037a54de0 2 2001 2 1 N T informix tempdbs

c000000037a54ec8 3 1 3 1 N informix logdbs

c000000037a54fb0 4 1 4 6 N informix userdbs

4 active, 2047 maximum

Chunks

address chk/dbs offset size free bpages flags pathname

c000000037a542b0 1 1 0 1000000 898655 PO- /home/informix/chunklink/rootdbs

c000000037a544a0 2 2 0 1000000 999947 PO- /home/informix/chunklink/tempdbs

c000000037a545c8 3 3 0 1000000 249947 PO- /home/informix/chunklink/logdbs

c000000037a546f0 4 4 0 1000000 182168 PO- /home/informix/chunklink/userdbs04

c000000037a54818 5 4 0 1000000 301634 PO- /home/informix/chunklink/userdbs05

c000000037a54940 6 4 0 1000000 957613 PO- /home/informix/chunklink/userdbs06

c000000037a54a68 7 4 0 1000000 947070 PO- /home/informix/chunklink/userdbs07

c000000037a54b90 8 4 0 1000000 942314 PO- /home/informix/chunklink/userdbs08

c000000037a54cb8 9 4 0 1000000 979816 PO- /home/informix/chunklink/userdbs09

9 active, 2047 maximum

3、以下是磁盘阵列使用情况：

LUN 1:

Redundancy Group:_____________________1

Active:_______________________________True

Data Capacity:________________________50 GB

WWN:__________________________________60060b000014f928000100000000000e

Number Of Business Copies:____________0

CAPACITY Totals for Redundancy Group 1:

REGULAR LUNs:_________________________50.097 GB

BUSINESS COPIES:______________________0 bytes

CAPACITY USAGE

Total Disk Enclosures:________________1

Redundancy Group:_____________________1

Total Disks:________________________6

Total Physical Size:________________400.543 GB

Allocated to Regular LUNs:__________50.097 GB

Allocated as Business Copies:_______0 bytes

Used as Active Hot Spare:___________66.753 GB

Used for Redundancy:________________176.379 GB

Unallocated (Available for LUNs):___107.312 GB

从以上信息可知：

已经分配使用的50.097 GB，未分配还可用的107.312 GB

/dev/vgdata