Creating index and none logging.
Question: Can you still receive the following Long Trnx on index enable is logging is turned off? 06:20:18 Aborting Long Transaction: tx 0x26d62388 username: informix uid: 1004 -458 Long transaction aborted. The database server (probably OnLine or INFORMIX-OnLine for NetWare) ran out of log space in which to record this transaction. A transaction that is not fully recorded cannot be rolled back. To preserve database integrity, the operating system ended the transaction and rolled it back automatically. All changes made since the start of the transaction have been removed. Terminate the application, and replan it so that it modifies fewer rows per transaction. Alternatively, contact the OnLine administrator to discuss increasing the number or the size of the logical logs. Be prepared to talk about the number of rows being updated or inserted and the size of each row. 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 ! " **************************************
Ernie - Your question is not really very clear - but I think the question is can you have a long transaction when creating an index if logging is turned off? The answer is yes - even with logging off an index creation statement still generates log records, whenever a new extent is allocated for example. MM
Thanks. That's what I was asking and looking for. ************************************** 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 MIKE MAGIE Sent: Tuesday, April 08, 2008 11:09 AM To: ids@iiug.org Subject: Re: Creating index and none logging. [11804] Ernie - Your question is not really very clear - but I think the question is can you have a long transaction when creating an index if logging is turned off? The answer is yes - even with logging off an index creation statement still generates log records, whenever a new extent is allocated for example. MM ******************************************************************************* 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!!