- 论坛徽章:
- 0
|
用informix自帶的BDL語言跑報表. 出現如下錯誤:
Fatal error in apyr910 at line 546 in module "apyr910T.4gl" ?
?-1330: A row could not be inserted into a temporary report table.
bdf 查磁盤空間正常:
sz_HP:/u/tiptop/apm/sql> bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 2097152 440128 1644120 21% /
/dev/vg00/lvol1 1014648 77984 835192 9% /stand
/dev/vg00/lvol8 5242880 907616 4301824 17% /var
/dev/vg00/lvol7 4194304 1530704 2646456 37% /usr
/dev/vg01/tiptop_u1
15728640 11729198 3874466 75% /u1
/dev/vg01/tiptop 20971520 4077736 16635776 20% /u
/dev/vg00/transaction
20971520 670752 19983576 3% /transaction
/dev/vg00/lvol6 4194304 19904 4141976 0% /tmp
/dev/vg00/lvol5 4194304 2441328 1739312 58% /opt
/dev/vg00/lvol4 2097152 2336 2078464 0% /home
192.168.31.30:/tiptop
1463898104 820605904 643292200 56% /mnt/csv
onstat -d 查temp dbs空間也正常:
BM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 22 days 13:56:36 -- 5413648 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
c000000119d94e60 1 0x1 1 1 N informix rootdbs
c00000011b464688 2 0x1 2 1 N informix plogdbs
c00000011b464808 3 0x1 3 1 N informix llogdbs
c00000011b464988 4 0x2001 4 1 N T informix tmpdbs
c00000011b464b08 5 0x41001 5 3 N B informix dbs1
5 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
c000000119d95028 1 1 0 1024000 921250 PO-- /dev/vg01/rinfxroot_cn
c00000011b460b88 2 2 0 512000 255947 PO-- /dev/vg01/rinfxplog_cn
c00000011b460d20 3 3 0 1024000 3947 PO-- /dev/vg01/rinfxllog_cn
c00000011b464028 4 4 0 1024000 1019398 PO-- /dev/vg01/rinfxtemp_cnc00000011b4641c0 5 5 0 10240000 193 PO-B /dev/vg01/rinfx01_cn
c00000011b464358 6 5 0 10240000 7216634 PO-B /dev/vg01/rinfx02_cn
c00000011b4644f0 7 5 0 10240000 10239997 PO-B /dev/vg01/rinfx03_cn
7 active, 32766 maximum
Expanded chunk capacity mode: enabled
還請各位大哥,指教,為何跑資料量比較大的報表,會出現這樣的狀況. |
|