Turn off logging for a single table

Hi all Informix IDS 7.3 or 9.2 / Unix Database Non-ANSI mode, Unbuffered logging. Is it possible to turn off logging, temporarily, for a specific DB table only in order to speed up subsequent updates over this? The table has 1 millon rows and 85% will be affected by the updates. (Table has indexes but not in fields for update) P.Magos

Pantelis You can alter table to RAW, however you need to drop all indexes, constraints etc. first and recreate after, so may not be best, otherwise no. Keith -----Original Message----- From: Pantelis Magos [mailto:pas@logifer.gr] Sent: Monday, September 15, 2003 12:08 To: ids@iiug.org Subject: Turn off logging for a single table [1871] Hi all Informix IDS 7.3 or 9.2 / Unix Database Non-ANSI mode, Unbuffered logging. Is it possible to turn off logging, temporarily, for a specific DB table only in order to speed up subsequent updates over this? The table has 1 millon rows and 85% will be affected by the updates. (Table has indexes but not in fields for update) P.Magos ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Informix 9.2 (not sure about 7.3) has RAW mode for tables. Changes to these tables are not logged, but you're not allowed to have indexes on raw tables. -----Original Message----- From: Pantelis Magos [mailto:pas@logifer.gr] Sent: Monday, September 15, 2003 7:08 AM To: ids@iiug.org Subject: Turn off logging for a single table [1871] Hi all Informix IDS 7.3 or 9.2 / Unix Database Non-ANSI mode, Unbuffered logging. Is it possible to turn off logging, temporarily, for a specific DB table only in order to speed up subsequent updates over this? The table has 1 millon rows and 85% will be affected by the updates. (Table has indexes but not in fields for update) P.Magos "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."

U can probably convert the table into RAW. U can try ALTER TABLE <table_name> type (RAW). Please keep in mind that you cannot have indexes and referential constraints on the table when you turn a table to RAW. Once you are done with your work, you can convert it back to logging table with the command: ALTER TABLE <table> type (standard) HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "Pantelis Magos" <pas@logifer.gr> To: ids@iiug.org Sent by: cc: forum.subscriber@ Subject: Turn off logging for a single table [1871] iiug.org 09/15/2003 04:08 AM Hi all Informix IDS 7.3 or 9.2 / Unix Database Non-ANSI mode, Unbuffered logging. Is it possible to turn off logging, temporarily, for a specific DB table only in order to speed up subsequent updates over this? The table has 1 millon rows and 85% will be affected by the updates. (Table has indexes but not in fields for update) P.Magos

I believe the raw table option is not available until version 9.3 or maybe 9.4. Rob Schmitz 913-345-6281 Rob.B.Schmitz@mail.sprint.com -----Original Message----- From: Rajib Sarkar [mailto:rsarkar@us.ibm.com] Sent: Monday, September 15, 2003 10:03 AM To: ids@iiug.org Subject: Re: Turn off logging for a single table [1874] U can probably convert the table into RAW. U can try ALTER TABLE <table_name> type (RAW). Please keep in mind that you cannot have indexes and referential constraints on the table when you turn a table to RAW. Once you are done with your work, you can convert it back to logging table with the command: ALTER TABLE <table> type (standard) HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "Pantelis Magos" <pas@logifer.gr> To: ids@iiug.org Sent by: cc: forum.subscriber@ Subject: Turn off logging for a single table [1871] iiug.org 09/15/2003 04:08 AM Hi all Informix IDS 7.3 or 9.2 / Unix Database Non-ANSI mode, Unbuffered logging. Is it possible to turn off logging, temporarily, for a specific DB table only in order to speed up subsequent updates over this? The table has 1 millon rows and 85% will be affected by the updates. (Table has indexes but not in fields for update) P.Magos