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
