Re: Error 458 - Long transaction aborted
Well, you don't have to increase the filespace for Informix,
you just have to add more logical logs (see onstat -l and
onparams for this).
Best Regards,
Octav
On Tue, Jul 27, 1999 at 02:41:32PM +0200, Michael Firschke wrote:
> Hello Informix-experts,
> we encountered a problem with long transactions in Informix.
> So we tried to enlarge the filespace for Informix, but
> with no effect. Is there any way out?
> TIA, Michael
>
>
> BEGIN WORK;
> LOCK TABLE n_ursprber IN EXCLUSIVE MODE;
> LOCK TABLE n_ursprung IN EXCLUSIVE MODE;
> LOCK TABLE r_n_urspr_std IN EXCLUSIVE MODE;
> LOCK TABLE r_std_komb_ub IN EXCLUSIVE MODE;
> UNLOAD TO "n_ursprber.V5403.unl" DELIMITER "|"
> SELECT * FROM n_ursprber;
> UNLOAD TO "n_ursprung.V5403.unl" DELIMITER "|"
> SELECT * FROM n_ursprung;
> UNLOAD TO "rn_ursprs.V5403.unl" DELIMITER "|"
> SELECT * FROM r_n_urspr_std;
> UNLOAD TO "rstd_kub.V5403.unl" DELIMITER "|"
> SELECT * FROM r_std_komb_ub;
> DELETE FROM r_n_urspr_std;
> DELETE FROM r_std_komb_ub;
> DELETE FROM n_ursprber;
> DELETE FROM n_ursprung;
> LOAD FROM "n_ursprber.sql" INSERT INTO n_ursprber;
> LOAD FROM "n_ursprung.sql" INSERT INTO n_ursprung;> ^
> F>> 458: Long transaction aborted.
>
>
> onstat -d>
> INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- Up 7 days 06:32:40 -- 74736
> Kby
> tes
>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 2193a100 1 2 1 1 M informix rootdbs
> 2193afd0 2 2 2 1 M informix stammdbs
> 2193b040 3 2 3 1 M informix statdbs
> 2193b0b0 4 2 4 1 M informix pnpdbs
> 2193b120 5 2001 5 3 N T informix tempdbs
> 2193b190 6 12 6 1 M B informix blobdbs1
> 2193b200 7 2 7 1 M informix scedbs
> 2193b270 8 12 8 1 M B informix blobdbs2
> 8 active, 2047 maximum
>
> Chunks
> address chk/dbs offset size free bpages flags pathname
> 2193a170 1 1 0 50000 36751 PO- /dev/rootdbs
> 2193a248 1 1 0 50000 0 MO- /dev/mrootdbs
> 2193a400 2 2 0 250000 239161 PO- /dev/stammdbs
> 2193aac0 2 2 0 250000 0 MO- /dev/mstammdbs
> 2193a4d8 3 3 0 250000 247371 PO- /dev/statdbs
> 2193ab98 3 3 0 250000 0 MO- /dev/mstatdbs
> 2193a5b0 4 4 0 25000 24662 PO- /dev/pnpdbs
> 2193ac70 4 4 0 25000 0 MO- /dev/mpnpdbs
> 2193a688 5 5 0 200000 199947 PO- /dev/tempdbs
> 2193a760 6 6 0 100000 ~99603 100000 POB /dev/blobdbs1
> 2193ad48 6 6 0 100000 0 MOB /dev/mblobdbs1
> 2193a838 7 7 0 1000000 474669 PO- /dev/scedbs
> 2193ae20 7 7 0 1000000 0 MO- /dev/mscedbs
> 2193a910 8 8 0 1000000 ~994822 1000000 POB /dev/blobdbs2
> 2193aef8 8 8 0 1000000 0 MOB /dev/mblobdbs2
> 2193a9e8 9 5 0 250000 249997 PO- /dev/tempdbs1
> 21e94830 10 5 0 250000 249997 PO- /dev/tempdbs2
> 10 active, 2047 maximum
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 22 84 88
Moldova, Republic of mailto:com@netinfo-moldova.com