Re: (LONGTX) V 9.30.UC2 How to get out of this

Posted in 2004

Rajib Sarkar — Mon, 12 Apr 2004 16:48:33 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E Content-type: multipart/alternative; Boundary="1__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E" --1__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable I'm assuming u didn't have the DYNAMIC_LOGS feature turned on ... In th= is case, please call Tech Support and they'll help you getting this xactio= n completed or maybe deleting this transaction. After that's done, you need to a) add more logs to make sure it completes the xaction or b) Load in smaller chunks and commit after a few records. Thanx much, Rajib Sarkar If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "Azeemuddin, = Basheer" = <bahmed@KNRQ.com> = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect (LONGTX) V 9.30.UC2 How to get= 04/12/2004 02:05 out of this = PM = = = = = = AIX 4.3.3 V 9.30 UC2 Informix Dynamic Server Version 9.30.UC2 -- On-Line (LONGTX) -- Up = 2 days 04:00:45 -- 737696 Kbytes Blocked:LONGTX Started a load job about 100,000 Records. After few minutes got LONGT= X. How to get out of this. Thanks Basheer sending to informix-list = --1__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> I'm assuming u didn't have the DYNAMIC_LOGS feature turned on ... In= this case, please call Tech Support and they'll help you getting this = xaction completed or maybe deleting this transaction. After that's done, you need to a) add more logs to make sure it completes the xaction or b) Load in smaller chunks and commit after a few records. Thanx much, Rajib Sarkar If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:10__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Azeemuddin, B= asheer" <bahmed@KNRQ.com>">"Azeemuddin, Basheer" &= lt;bahmed@KNRQ.com> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE4E= 7DF11FC7E8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"Azeemuddin, Basheer" <bahmed@KNRQ= .com> Sent by: owner-informix-list@iiug.org 04/12/2004 02:05 PM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> informix-list@iiug.org</td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">cc</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">Subject</div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE4E7DF11FC7E8f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> (LONGTX) V 9.30.UC2 How to get out of this</t= d></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE4E7DF11= FC7E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE4E7DF11FC7E8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <tt>AIX 4.3.3 V 9.30 UC2 Informix Dynamic Server Version 9.30.UC2     -- On-Line (LONG= TX) -- Up 2 days 04:00:45 -- 737696 Kbytes  Blocked:LONGTX Started a load job about 100,000 Records.  After  few minutes= got LONGTX. How to get out of this. Thanks Basheer sending to informix-list </tt> </body></html>= --1__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E-- --0__=88BBE4E7DF11FC7E8f9e8a93df938690918c88BBE4E7DF11FC7E Content-type: image/gif; name="graycol.gif"