Reorganizing a table to bring down the number of e
A user tried to consolidate a large table's 17 extents with "ALTER FRAGMENT ON TABLE ... INIT" and hit error 458/12204, a long transaction abort because the operation filled the logical logs. Suggestions were to add/enlarge logical logs or turn logging off. John Miller recommended simply switching the table to RAW (unlogged) for the operation, and the poster confirmed the sequence: alter next size, alter table type (raw), alter fragment init, then alter table type (standard). A follow-up noted raw tables exist in 7.31, but indexes on raw tables aren't allowed until version 10.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all, I use "alter fragment on table rtistand init in da11dbs" to bring down its 17 extents. I got the error "458: Long transaction aborted" "12204: RSAM error: Long transaction detected." The table is a large one (row size 30 - No. of row 16,948,237). The server runs out of log space for this transaction. The only way to overcome is to increase the logical log size. Are there other ways without increasing the logical log size when using this method? Thanks Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au Disclaimer: This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it together with any attachments from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any opinions expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the opinions of Ruralco Holdings Limited or any of its subsidiaries (collectively "Ruralco"). Although all care has been taken to screen this communication for viruses, neither the sender nor Ruralco warrants that any communication via the Internet is free of errors, viruses, interception or interference. Information is distributed without warranties of any kind.
Turn logging off ? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Thursday, 28 February 2008 1:24 p.m. To: ids@iiug.org Subject: Reorganizing a table to bring down the number .... [11451] Hi all, I use "alter fragment on table rtistand init in da11dbs" to bring down its 17 extents. I got the error "458: Long transaction aborted" "12204: RSAM error: Long transaction detected." The table is a large one (row size 30 - No. of row 16,948,237). The server runs out of log space for this transaction. The only way to overcome is to increase the logical log size. Are there other ways without increasing the logical log size when using this method? Thanks Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au Disclaimer: This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it together with any attachments from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any opinions expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the opinions of Ruralco Holdings Limited or any of its subsidiaries (collectively "Ruralco"). Although all care has been taken to screen this communication for viruses, neither the sender nor Ruralco warrants that any communication via the Internet is free of errors, viruses, interception or interference. Information is distributed without warranties of any kind. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
Either increase the log size, number of logs, or turn off logging, if you can. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Murray Wood Sent: Wednesday, February 27, 2008 6:35 PM To: ids@iiug.org Subject: RE: Reorganizing a table to bring down the num.... [11452] Turn logging off ? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Thursday, 28 February 2008 1:24 p.m. To: ids@iiug.org Subject: Reorganizing a table to bring down the number .... [11451] Hi all, I use "alter fragment on table rtistand init in da11dbs" to bring down its 17 extents. I got the error "458: Long transaction aborted" "12204: RSAM error: Long transaction detected." The table is a large one (row size 30 - No. of row 16,948,237). The server runs out of log space for this transaction. The only way to overcome is to increase the logical log size. Are there other ways without increasing the logical log size when using this method? Thanks Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au Disclaimer: This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it together with any attachments from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any opinions expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the opinions of Ruralco Holdings Limited or any of its subsidiaries (collectively "Ruralco"). Although all care has been taken to screen this communication for viruses, neither the sender nor Ruralco warrants that any communication via the Internet is free of errors, viruses, interception or interference. Information is distributed without warranties of any kind. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
I might have missed the version, but you can also alter this table to a raw table, which just turns off logging for this table only. Then= alter it back to standard when you complete your operation. John = "Knox, Ernest" = <eknox@searshc.co = m> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect RE: Reorganizing a table to brin= g 02/27/2008 05:00 down the num.... [11453] = PM = = = Please respond to = ids@iiug.org = = = Either increase the log size, number of logs, or turn off logging, if y= ou can. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Murray Wood Sent: Wednesday, February 27, 2008 6:35 PM To: ids@iiug.org Subject: RE: Reorganizing a table to bring down the num.... [11452] Turn logging off ? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Thursday, 28 February 2008 1:24 p.m. To: ids@iiug.org Subject: Reorganizing a table to bring down the number .... [11451] Hi all, I use "alter fragment on table rtistand init in da11dbs" to bring down its 17 extents. I got the error "458: Long transaction aborted" "12204: RSAM error: Lon= g transaction detected." The table is a large one (row size 30 - No. of row 16,948,237). The server runs out of log space for this transaction. The only way to overcome is to increase the logical log size. Are there other ways without increasing the logical log size when using= this method? Thanks Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au Disclaimer: This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it together with any= attachments from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any opinions expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to b= e the opinions of Ruralco Holdings Limited or any of its subsidiaries (collectively "Ruralco"). Although all care has been taken to screen this communication for viruses, neither the sender nor Ruralco warrants that any communication via the Internet is free of errors, viruses, interception or interference. Information is distributed without warranties of any kind. ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =
Thanks John,
alter table rtistand next size 200000;
alter table rtistand type (raw); -- unlogging the table
alter fragment on table rtistand init in data11dbs; //reorg. the extents
alter table rtistand type (standard); //logging back the table.Cheers
Long N
=====================================
"John Miller iii"
<miller3@us.ibm.c To: ids@iiug.org
om> cc:
Sent by: Subject: RE: Reorganizing a table to bring down the num.... [11455]
ids-bounces@iiug.
org
28/02/2008 11:17
AM
Please respond to
ids
I might have missed the version, but you can also alter this table
to a raw table, which just turns off logging for this table only. Then=
alter it back to standard when you complete your operation.
John
=
"Knox, Ernest" =
<eknox@searshc.co =
m> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
RE: Reorganizing a table to brin=
g
02/27/2008 05:00 down the num.... [11453] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Either increase the log size, number of logs, or turn off logging, if y=
ou
can.
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Murray
Wood
Sent: Wednesday, February 27, 2008 6:35 PM
To: ids@iiug.org
Subject: RE: Reorganizing a table to bring down the num.... [11452]
Turn logging off ?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Long Nguyen
Sent: Thursday, 28 February 2008 1:24 p.m.
To: ids@iiug.org
Subject: Reorganizing a table to bring down the number .... [11451]
Hi all,
I use "alter fragment on table rtistand init in da11dbs" to bring down
its
17 extents.
I got the error "458: Long transaction aborted" "12204: RSAM error: Lon=
g
transaction detected."
The table is a large one (row size 30 - No. of row 16,948,237).
The server runs out of log space for this transaction.
The only way to overcome is to increase the logical log size.
Are there other ways without increasing the logical log size when using=
this method?
Thanks
Long Huy Nguyen
MIS(Analyst Programmer)
Ruralco Limited
P.O.Box 515
Wentworthville NSW 2145
(Ph) 02 9688 8528 (Fax) 02 9896 7763
lnguyen@ruralco.com.au
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No
confidentiality
or privilege is waived or lost by any mistransmission. If you receive
this
correspondence in error, please immediately delete it together with any=
attachments from your system and notify the sender. You must not
disclose,
copy or rely on any part of this correspondence if you are not the
intended
recipient.
Any opinions expressed in this message are those of the individual
sender,
except where the sender expressly, and with authority, states them to b=
e
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for
viruses,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
***********************************************************************=
*
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately delete it together with any
attachments from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended
recipient.
Any opinions expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for viruses,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
Will that method work for IDS version 7.31.UD8?
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long
Nguyen
Sent: Wednesday, February 27, 2008 7:50 PM
To: ids@iiug.org
Subject: RE: Reorganizing a table to bring down the num.... [11456]
Thanks John,
alter table rtistand next size 200000;
alter table rtistand type (raw); -- unlogging the table
alter fragment on table rtistand init in data11dbs; //reorg. the extents
alter table rtistand type (standard); //logging back the table.Cheers
Long N
=====================================
"John Miller iii"
<miller3@us.ibm.c To: ids@iiug.org
om> cc:
Sent by: Subject: RE: Reorganizing a table to bring down the num.... [11455]
ids-bounces@iiug.
org
28/02/2008 11:17
AM
Please respond to
ids
I might have missed the version, but you can also alter this table
to a raw table, which just turns off logging for this table only. Then=
alter it back to standard when you complete your operation.
John
=
"Knox, Ernest" =
<eknox@searshc.co =
m> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
RE: Reorganizing a table to brin=
g
02/27/2008 05:00 down the num.... [11453] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Either increase the log size, number of logs, or turn off logging, if y=
ou
can.
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Murray
Wood
Sent: Wednesday, February 27, 2008 6:35 PM
To: ids@iiug.org
Subject: RE: Reorganizing a table to bring down the num.... [11452]
Turn logging off ?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Long Nguyen
Sent: Thursday, 28 February 2008 1:24 p.m.
To: ids@iiug.org
Subject: Reorganizing a table to bring down the number .... [11451]
Hi all,
I use "alter fragment on table rtistand init in da11dbs" to bring down
its
17 extents.
I got the error "458: Long transaction aborted" "12204: RSAM error: Lon=
g
transaction detected."
The table is a large one (row size 30 - No. of row 16,948,237).
The server runs out of log space for this transaction.
The only way to overcome is to increase the logical log size.
Are there other ways without increasing the logical log size when using=
this method?
Thanks
Long Huy Nguyen
MIS(Analyst Programmer)
Ruralco Limited
P.O.Box 515
Wentworthville NSW 2145
(Ph) 02 9688 8528 (Fax) 02 9896 7763
lnguyen@ruralco.com.au
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No
confidentiality
or privilege is waived or lost by any mistransmission. If you receive
this
correspondence in error, please immediately delete it together with any=
attachments from your system and notify the sender. You must not
disclose,
copy or rely on any part of this correspondence if you are not the
intended
recipient.
Any opinions expressed in this message are those of the individual
sender,
except where the sender expressly, and with authority, states them to b=
e
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for
viruses,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
***********************************************************************=
*
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately delete it together with any
attachments from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended
recipient.
Any opinions expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for viruses,
neither the sender nor Ruralco warrants that any communica
7.31 does support raw tables, but you are not allowed
to have indexes on the table with raw tables until version 10.
John
=
"Knox, Ernest" =
<eknox@searshc.co =
m> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
RE: Reorganizing a table to brin=
g
02/27/2008 06:04 down the num.... [11457] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Will that method work for IDS version 7.31.UD8?
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of L=
ong
Nguyen
Sent: Wednesday, February 27, 2008 7:50 PM
To: ids@iiug.org
Subject: RE: Reorganizing a table to bring down the num.... [11456]
Thanks John,
alter table rtistand next size 200000;
alter table rtistand type (raw); -- unlogging the table
alter fragment on table rtistand init in data11dbs; //reorg. the extent=s
alter table rtistand type (standard); //logging back the table.Cheers
Long N
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"John Miller iii"
<miller3@us.ibm.c To: ids@iiug.org
om> cc:
Sent by: Subject: RE: Reorganizing a table to bring down the num....
[11455]
ids-bounces@iiug.
org
28/02/2008 11:17
AM
Please respond to
ids
I might have missed the version, but you can also alter this table
to a raw table, which just turns off logging for this table only. Then=3D=
alter it back to standard when you complete your operation.
John
=3D
"Knox, Ernest" =3D
<eknox@searshc.co =3D
m> =3D
To
Sent by: ids@iiug.org =3D
ids-bounces@iiug. =3D
cc
org =3D
Subj=3D
ect
RE: Reorganizing a table to brin=3D
g
02/27/2008 05:00 down the num.... [11453] =3D
PM =3D
=3D
=3D
Please respond to =3D
ids@iiug.org =3D
=3D
=3D
Either increase the log size, number of logs, or turn off logging, if y=
=3D
ou
can.
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Murray
Wood
Sent: Wednesday, February 27, 2008 6:35 PM
To: ids@iiug.org
Subject: RE: Reorganizing a table to bring down the num.... [11452]
Turn logging off ?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Long Nguyen
Sent: Thursday, 28 February 2008 1:24 p.m.
To: ids@iiug.org
Subject: Reorganizing a table to bring down the number .... [11451]
Hi all,
I use "alter fragment on table rtistand init in da11dbs" to bring down
its
17 extents.
I got the error "458: Long transaction aborted" "12204: RSAM error: Lon=
=3D
g
transaction detected."
The table is a large one (row size 30 - No. of row 16,948,237).
The server runs out of log space for this transaction.
The only way to overcome is to increase the logical log size.
Are there other ways without increasing the logical log size when using=
=3D
this method?
Thanks
Long Huy Nguyen
MIS(Analyst Programmer)
Ruralco Limited
P.O.Box 515
Wentworthville NSW 2145
(Ph) 02 9688 8528 (Fax) 02 9896 7763
lnguyen@ruralco.com.au
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No
confidentiality
or privilege is waived or lost by any mistransmission. If you receive
this
correspondence in error, please immediately delete it together with any=
=3D
attachments from your system and notify the sender. You must not
disclose,
copy or rely on any part of this correspondence if you are not the
intended
recipient.
Any opinions expressed in this message are those of the individual
sender,
except where the sender expressly, and with authority, states them to b=
=3D
e
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for
viruses,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
***********************************************************************=
=3D
*
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
=3D
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Disclaimer:
This correspondence is for the named person's use only. It may contain
co