Error 405 - Long transaction aborted.

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

Heres how I would do it in version 5 , ( until we upgrade soon ) :- 1st of all , deal with each table individually if possible. I.e lock , unload, delete , load. Depending on the size of the table data you are dealing with you may also ave to do the following : instead of delete , simply drop the table - much faster anyway; instead of load use dbload utility, allows batches of rows to be inserted so you don't have to re-start from the beginning if it fails halfway thru. Hope it helps. Michael Firschke <berlin@gmx.de> wrote in message news:379DA755.5ABCD500@gmx.de... > 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