informix11.5创建了5个tmpdbs,为什么只用到了tmpdbs2,还不时报full,其它4个不使用,有遇过这种问题的吗?或知道怎么回事?
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
c000000a0782a030 1 0x40001 1 2 2048 N B informix rootdbs
c000000a0c4cf2f0 2 0x40001 2 1 2048 N B informix plogdbs
c000000a0c4cf490 3 0x40001 3 20 2048 N B informix llogdbs
c000000a0c4cf630 4 0x40001 4 1 2048 N B informix tmpdbs1
c000000a0c4cf7d0 5 0x42001 5 3 2048 N TB informix tmpdbs2
c000000a0c4cf970 6 0x42001 6 2 2048 N TB informix tmpdbs3
c000000a0c4cfb10 7 0x42001 7 2 2048 N TB informix tmpdbs4
c000000a0c4cfcb0 8 0x42001 8 2 2048 N TB informix tmpdbs5
#onspaces -c -d tmpdbs1 -p /opt/informix1/chk/tmpchk1-o 0 -s 4000000
#onspaces -c -d tmpdbs2 -p /opt/informix1/chk/tmpchk2-o 0 -s 4000000
#onspaces -c -d tmpdbs3 -p /opt/informix1/chk/tmpchk3-o 0 -s 4000000
#onspaces -c -d tmpdbs4 -p /opt/informix1/chk/tmpchk4-o 0 -s 4000000
#onspaces -c -d tmpdbs5 -p /opt/informix1/chk/tmpchk5-o 0 -s 4000000
$ onstat -c|grep DBSPACETEMP
# DBSPACETEMP - The list of dbspaces used to store temporary
DBSPACETEMP tmpdbs2 tmpdbs3 tmpdbs4 tmpdbs5
收起c000000a0c4cf630 4 0x40001 4 1 2048 N B informix tmpdbs1
c000000a0c4cf7d0 5 0x42001 5 3 2048 N TB informix tmpdbs2
c000000a0c4cf970 6 0x42001 6 2 2048 N TB informix tmpdbs3
c000000a0c4cfb10 7 0x42001 7 2 2048 N TB informix tmpdbs4
c000000a0c4cfcb0 8 0x42001 8 2 2048 N TB informix tmpdbs5
c000000a0c4e1b10 4 4 0 2000000 1999297 PO-B- /opt/informix1/chk/tmpchk1
c000000a0c4e1d10 5 5 0 2000000 1352329 PO-B- /opt/informix1/chk/tmpchk2
c000000a0c4e2030 6 6 0 2000000 1999947 PO-B- /opt/informix1/chk/tmpchk3
c000000a0c4e2230 7 7 0 2000000 1999947 PO-B- /opt/informix1/chk/tmpchk4
c000000a0c4e2430 8 8 0 2000000 1999947 PO-B- /opt/informix1/chk/tmpchk5
c000000a0c5c3030 503 5 0 2000000 1978424 PO-B- /opt/informix1/chk/tmpchk2a
c000000a0c5c3230 504 6 0 2000000 1999997 PO-B- /opt/informix1/chk/tmpchk3a
c000000a0c5c3430 505 7 0 2000000 1999997 PO-B- /opt/informix1/chk/tmpchk4a
c000000a0c5c3630 506 8 0 2000000 1999997 PO-B- /opt/informix1/chk/tmpchk5a
c000000a0c63bc30 757 5 0 2000000 1999997 PO-B- /opt/informix1/chk/tmpchk2b
收起