Hi Dave, Hope your Reorg has finished. Roll forward information is available from a get snapshot for database. You should get information like Current log being processed, Log phase in progress, Time of Log record currently processed.
Also, there has been some discussion in the newsgroups about only using logs that DB2 has finished with. Regards, Bruce -----Original Message----- From: Bargeron, Dave [SMTP:[EMAIL PROTECTED]] Sent: Friday, 5 April 2002 7:54 PM To: '[EMAIL PROTECTED]' Subject: [DB2EUG] DB2/NT - reorgs and rollforward Hi Listers, Hopefully someone can shed some light for us ? We are running DB2 v.7.1-FP5 on NT. Logs from an active database are shipped to another server and applied to a standby database which is in rollforward pending state. All has been working fine until... Last weekend we ran a couple of reorgs on very large tables and the logs produced shipped to the standby server . However the rollforward of a log (32 meg) produced during the reorgs has been running for over 24 hrs! Normally these logs are applied in 15 mins. - does the reorg of the active database have an impact on the rollforward of the log on the standby database ? - has anyone seen this before or have an idea when I can expect the rollforward to complete ? - can we monitor a rollforward (rather than 'get db cfg for db') ? Thanks Dave Bargeron LloydsTSB Bank UK ------------------------------------------------------------------------ ----------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. evolvebank.com is a division of Lloyds TSB Bank plc. Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in England, number 2065. Telephone No: 020 7626 1500 Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone No: 0131 225 4555 Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the Personal Investment Authority and represent only the Scottish Widows and Lloyds TSB Marketing Group for life assurance, pensions and investment business. Members of the UK Banking Ombudsman Scheme and signatories to the UK Banking Code. ------------------------------------------------------------------------ ----------------------------------------------- << File: ATT00000.html >> - ::: 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
