help me with Log files
Posted in 2003
Hi,
I am running IDS 9.3 on WinNT, when i insert or upload big sizing data files
into Blob field in one database, so data files is big that it needs much log
spaces (Log files) to help long transaction successfully, i must often add
much log files as i insert big data file into database, the problem here is
that cooked Log files could not be freed by IDS, consequently that next insert
activity will be stucked by lack of log spaces needed and then transaction
will be interrupted when transaction TIME_OUT values expired. To free log
files physically, i often drop cooked log files and then add new log files for
next transaction.
Question: How to free automatically cooked log files (Log files backed up for
any transaction) ?, i used to use onparams utility to add or drop Log files.
Thanks,
Bernard.
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!