Leslie
The answer depends on how your have your system configured. Lets go with
the most common case, LOGPRIMARY = 10 and LOGSECOND=0
In this case DB2 will not archive any of the 10 log files as there are
still active transactions in them. Once all 10 log files are allocated and
used, if the transaction has not completed then it will be terminated due
to a log full condition.
If you increase your LOGSECOND then DB2 will automatically consume the
extra log files as needed.
Once the transaction has completed and there are no active transactions in
any of the log files then DB2 will start archiving them.
If you set LOGSECOND=-1 then you are triggering INFINITE ACTIVE LOGGING, in
which case we will only consume LOGPRIMARY. Once the 10th log is filled it
will be archived, even though there are active transactions in it. If the
system were to crash after the archive has completed then restart will
automatically recall the required log files. We do keep 8 cached active log
files for the purpose of rollback in the overflow logpath. This number can
be changed with the DB2_NUM_CAL registry variable.
Hope this helps.
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
"Pendlebury-Bowe,
Leslie"
<Leslie.Pendlebur To
[EMAIL PROTECTED] [EMAIL PROTECTED]
m> cc
Sent by:
owner-db2eug@Lugw Subject
ash.org [DB2EUG] quick question on V8 ...
and Active/Archive logs
01/23/2003 10:41
AM
Please respond to
"Pendlebury-Bowe,
Leslie"
<Leslie.Pendlebur
[EMAIL PROTECTED]
m>
Guys
if I have a DB with LOGRETAIN amd USEREXIT Enabled .. + 10 active logs ...
what happens if I have a long running UOW (that backs out in the end , see
below) .. will it ...
1. use all 10 actives and not issue an archive but cause db2 to grind to a
hault
or
2. use all 10 actives then start Archiving
or
3. use one Active then archive it and move on to the next active .. making
use of reuse from renaming the old Active ... usual stuff for normal
transactions.
I've tried to get this info from the V8 Recovery Guide .. but do not seem
to
find exactly what I am looking for with respect to long running uow's .
If I have missed something in the book maybe somebody can point me to it?
the book is at :
ftp://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2hae80.pdf
I think that it will be Number 1 above ... am I correct?
Leslie
***********************************************************************************************
The information contained in this message or any of its attachments may be
confidential and is intended for the exclusive use of the addressee(s). Any
disclosure, reproduction, distribution or other dissemination or use of
this communication is strictly prohibited without the express permission of
the sender. The views expressed in this email are those of the individual
and not necessarily those of Sony or Sony affiliated companies. Sony email
is for business use only.
This email and any response may be monitored by Sony United Kingdom
Limited.
(04)
***********************************************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
