Wayne, I'm pity but you are wrong. Before DB2V9, LRSN is unique for the same member. Beginning from DB2V9, LRSN is unique only for the same page. When two updates occur inside the interval of 16 microseconds, thay may receive the same LRSN.
See for example http://www.redbooks.ibm.com/redbooks/pdfs/sg247473.pdf page 114 On Wed, Oct 29, 2008 at 6:29 PM, Wayne Driscoll <[EMAIL PROTECTED]>wrote: > Arie, > LRSN is unique. The reason LRSN is used in Data Sharing is because the log > RBA is not unique. LRSN's are guaranteed to be unique and ever-increasing, > so you have no need for an programmatic sequence number. > > Wayne Driscoll > Product Developer > NOTE: All opinions are strictly my own. > > > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On > Behalf > Of Arie Kremer > Sent: Wednesday, October 29, 2008 11:05 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: DB2 IFI LRSN sequence question > > Hi all, > > I've developed an IFCID 0306 used program to retrieve the log records from > DB2 log. The program is used now under the Data Sharing Environment, i.e. > LRSN is the key. But LRSN is not unique, and therefore a number of records > may be addressed by the same LRSN. > My question - could I be sure that when one applies IFI more than one time > on the same scope, IFI ALWAYS returns the records with the same LRSN in the > same order? In other words - could I maintain my own sequence counter, in > addition to LRSN, to provide the unique access to any record. > > Best Regards > Arie Kremer > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
