今天检查用户小机磁盘情况.
1.
[sx_bjyc01@/]df -g
文件系统 GB 块 可用 %Used Iused %Iused 安装于
/dev/hd4 1.00 0.98 3% 2217 1% /
/dev/hd2 10.00 2.32 77% 50041 9% /usr
/dev/hd9var 6.00 5.04 16% 1005 1% /var
/dev/hd3 4.00 1.15 72% 3156 2% /tmp
/dev/hd1 1.00 0.96 5% 121 1% /home
/proc - - - - - /proc
/dev/hd10opt 8.00 7.96 1% 948 1% /opt
/dev/lv00 0.12 0.12 4% 18 1% /var/adm/csd
/dev/tcbackup 39.88 19.17 52% 6 1% /tcbackup
/dev/tcfenc1 1.00 1.00 1% 4 1% /home/db2fenc1
/dev/tcinst1 3.00 0.51 83% 1433 2% /home/db2inst1
/dev/tcarch 30.00 3.16 90% 110 1% /tcarch
/dev/tcsysdata 10.00 9.65 4% 443 1% /tcsysdata
/dev/tctmpdata 10.00 2.82 72% 15 1% /tctmpdata
/dev/tcusrdata 45.00 0.07 100% 44 1% /tcusrdata
/dev/lv1 20.00 13.35 34% 96029 3% /l3app
发现数据库的表空间目录/tcusrdata满了 .
2 .查看/tcusrdata属于哪个vg
[sx_bjyc01@/]lsvg -o
l3appvg
tcdatavg
tcarchvg
tcbackvg
rootvg
[sx_bjyc01@/]lsvg -l tcdatavg
tcdatavg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
tcinst1 jfs2 48 48 1 open/syncd /home/db2inst1
tcfenc1 jfs2 16 16 1 open/syncd /home/db2fenc1
tcsysdata jfs2 160 160 1 open/syncd /tcsysdata
tctmpdata jfs2 160 160 1 open/syncd /tctmpdata
tcusrdata jfs2 720 720 2 open/syncd /tcusrdata
loglv04 jfs2log 1 1 1 open/syncd N/A
/tcusrdata 属于tcdatavg
3、查看tcdatavg还剩余有多少空间
[sx_bjyc01@/]lsvg tcdatavg
VOLUME GROUP: tcdatavg VG IDENTIFIER: 00c3e36a00004c0000000109a3bba0db
VG STATE: active PP SIZE: 64 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 1278 (81792 megabytes)
MAX LVs: 256 FREE PPs: 173 (11072 megabytes)
LVs: 6 USED PPs: 1105 (70720 megabytes)
OPEN LVs: 6 QUORUM: 2
TOTAL PVs: 2 VG DESCRIPTORS: 3
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 2 AUTO ON: no
MAX PPs per PV: 1016 MAX PVs: 32
LTG size: 128 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
剩余pps :10G
4. 增加/tcusrdata的大小
chfs -a size=50G /tcusrdata
5、增加表空间大小。
ALTER TABLESPACE TC_DATA
ADD
(File '/tcusrdata/tradectr/userfile/datafile16.dat' 128000);
这是小弟写增加表空间的操作步骤,还请各位前辈指点还有那些要注意的 !!
谢谢指正 !!
收起