Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Madeline Wu — — source: Informix-list mailing list archive (1991-1998)
I test a long transaction in Online 5.0.
Only one user in this Online. That is me.
The long transaction is like this...
begin work;
update table1 set field1='1';
update table2 set field2='1';
update table3 set field3='1'; :
:
:
update table50 set field50='1';commit work;
I set LTXHWM=50 & LTXEHWM=60. When logical logs
used 60%, this transaction began rollback. When
rollback used the last logical log, many
checkpoint happend. When the last logical log
used 100%, "The logical logs are full---Backup
is need." showed on the sys log file. No matter
I used Auto-Backup or Continue-Backup, I still
couldn't backup all full logical fogs. The
Online 5.0 cannot work anymore.
I thought this Online 5.0 got some problems with
the AIX UNIX 3.2.5. So I test again on SCO UNIX
whit Online 5.0, the same thing happen. Why????
It is a bug on Online 5.0? Or I cannot test like
that? How can I test a long trancation and
rollback normally?
--
Madeline Wu from Taiwan.......
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.