一、 目前现网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