unknown
2009-12-18 16:27:33 UTC
Adaptive Server Enterprise/12.5.3/EBF 12332
ESD#1/P/RS6000/AIX
Hi,
I have a log full in a db with trunc log on checkpoint on.
There are 3 bcp jobs that were in log suspend. I tried to
kill the jobs and now they are in "rollback" state & seem to
be accumulating I/O. I am wondering if they are really doing
anything or not? Also, not wanting to increase the size of
the log (developers mistake) I am trying to dump tran to
file (no space in log), dump with trunc_only (can't trunc
log) and finally dump with no_log. Does anyone know if the
rollback of the three bcp's will complete or will the full
log stop it eventually?
thx,
rick_806
ESD#1/P/RS6000/AIX
Hi,
I have a log full in a db with trunc log on checkpoint on.
There are 3 bcp jobs that were in log suspend. I tried to
kill the jobs and now they are in "rollback" state & seem to
be accumulating I/O. I am wondering if they are really doing
anything or not? Also, not wanting to increase the size of
the log (developers mistake) I am trying to dump tran to
file (no space in log), dump with trunc_only (can't trunc
log) and finally dump with no_log. Does anyone know if the
rollback of the three bcp's will complete or will the full
log stop it eventually?
thx,
rick_806