Problem with Temp Tables and Logging
To you first question try creating the temp table "with no log" this will
prevent (or reduce) the large transaction of the insert.
Also look at your isolation level. some isolation levels will lock rows
on read. Which may also be causing you problem.
Russ....
} From ellis.oncontact.com!rmy.emory.edu!ilist Wed Nov 15 00:47:14 1995
} From: Mark Christmas <christma@rmy.emory.edu>
} Message-Id: <4831bt$i8b@kannews.ca.newbridge.com>
} Subject: Problem with Temp Tables and Logging
} Date: 11 Nov 1995 20:34:05 GMT
} Reply-To: Mark Christmas <christma@rmy.emory.edu>
} Organization: Newbridge Networks Corporation
} Sender: informix-list-owner@rmy.emory.edu
} To: informix-list@rmy.emory.edu
} X-Informix-List-To: russell@oncontact.com
} X-Informix-List-Id: <news.18884>
}
} We are encountering a curious situation: A query is run that creates a
} temporary table (implicit). It ran fine for quite a while, but now we get -458
} (long transaction aborted). I know that we need to create a tempdbspace (right
} now it all goes into our rootdbs), but the temporary table data is small (only
} 10K of data). We have about 150Mb free, and our logs are 400K x 40 files.
} We do go through the log files quickly (about every 45 seconds). Is it possible
} that the query starts, then the logs roll right around and the query, not being
} completed, gets the boot?
} It is only a select, but it does contain ORDER BY, and that phrase is causing
} the query to take forever to run.
} Has anyone seen anything like this before?
}
} Also, I have another database that has so little space, that the oninit fails
} because pages cannot be allocated. If I perform an oninit -s, can I get up
} enough to add a chunk?
}
} Thanks in advance...
}
} Mark Christmas
} CrossKeys Systems Corp
}
Russell P. Kahler |||||/// ----------
Internet: russell@oncontact.com ======== / Uh...
on!contact Software . | O O | /Just reboot
W67 N250A Evergreen Blvd | v_' / --> that will /
Cedarburg, WI 53012 # _| |_ fix it /
(414) 375-6555 (#) ( ) ----------
# //|* *|
#//( * )/
# =====
# ( )
Blah, Blah, Blah. # || ||
.#---'| |----.
#----' -----