- 论坛徽章:
- 0
|
我的HDR辅助服务器onstat -d结果:
[symsun@ccgsSec symsun]$ onstat -d
Informix Dynamic Server Version 9.40.UC1G2 -- Read-Only (Sec) -- Up 3 days 21:02:27 -- 476304 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
0x2b2697d8 1 0x61801 1 1 NL B informix rootdbs
0x2b3dacc8 2 0x60801 2 1 NL B informix logdbs
0x2b3dae18 3 0x40801 3 1 NL B informix datadbs
0x2b988018 4 0x40811 4 1 NLBB informix sblbdbs
0x2b988168 5 0x42001 5 1 N TB informix tempdbs
5 active, 2047 maximum
Note: For BLOB chunks, the number of free pages shown is out of date.
Run 'onstat -d update' for current stats.
Chunks
address chunk/dbs offset size free bpages flags pathname
0x2b269928 1 1 0 2000000 1298046 PI-B /home/data/DATA
0x2b269db0 2 2 2000000 4000000 599947 PI-B /home/data/DATA
0x2b3da830 3 3 6000000 20000000 17981205 PI-B /home/data/DATA
0x2b3da9b8 4 4 26000000 2000000 ~2000000 2000000 PIBB /home/data/DATA
0x2b3dab40 5 5 28000000 2000000 1999947 PO-B /home/data/DATA
5 active, 32766 maximum
Expanded chunk capacity mode: always
文件/home/informix/etc/onconfig内容片段如下:
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs # Default temp dbspaces
# DUMP*:
为何在辅助服务器上不能创建临时表?
请高手指点。
[ 本帖最后由 xxyyy 于 2007-6-14 22:35 编辑 ] |
|