Re: Turn off logging at the session level?

Fred Lee wrote: > > I am new to the Informix (ex-Ingres, Oracle, Sybase DBA). Please help! > > We are running V7.23 on HPUX-10.20. We have a few tables (>1.5Million > rows) that need to reload weekly. Each run fills up the logical log file > (archive to disk) real fast (600M within 6 hours). I am wondering if I > can turn off logging for these weekly loads (I cannot turn off logging > for the database because other users are on the system). Not easily. You have to turn off logging for the entire database which can only be done as part of a Level 0 Full system backup. After the load the logging will have to be turned back on with another level 0 archive. Best thing to do: 1) Make sure logs are being backed up continuously, at least during the load. 2) Modify the load program to (FLUSH any INSERT CURSORS and ) COMMIT every few thousand rows and BEGIN WORK again so that you do not have any transaction spanning more than a few log files and the log files can be released for reuse as soon as they are backed up. (If you use insert cursors: DECLARE ... CURSOR WITH HOLD...). 3) Increase the number and/or size of log files. Art S. Kagel