Bruce Williamson

Howzit Folks?

I'm trying to understand LOG COUNT vs LOGAPPLY COUNT which currently has a discrepancy of about 400k records but the log apply iterations are only processing between 20 and 500 records per iteration.

Is this discrepancy due to rollbacks in the logs or is there some other explanation?

Any info appreciated.


Commonwealth Bank
Bruce Williamson
Database Administrator
CBM Operations
Core Banking Modernisation
2 Dawn Fraser Avenue
Sydney Olympic Park

P: 02 9115-6535
M: 04 7830-2992
E: [login to unmask email]<mailto:[login to unmask email]>

Our vision is to be Australia's finest financial services organisation through excelling in customer service.

************** IMPORTANT MESSAGE *****************************
This e-mail message is intended only for the addressee(s) and contains information which may be
If you are not the intended recipient please advise the sender by return email, do not use or
disclose the contents, and delete the message and any attachments from your system. Unless
specifically indicated, this email does not constitute formal advice or commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please reply to this
e-mail by typing Unsubscribe in the subject line.

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv