the end of the world - or at least log sequence #

Chris Hoelscher

the end of the world - or at least log sequence #
I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year

Can someone point me to documentation that discusses our options - or even better yet - share those options here?

1) Update resume?
2) Employ datasharing? (this has been on our table for years, but keeps getting pushed back)
3) Update copy of resume?

Thanks

Chris Hoelscher



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

David Simpson

Re: the end of the world - or at least log sequence #
(in response to Chris Hoelscher)
While keeping your resume up to date is never a bad idea, I believe that IBM level 2 will help you with resetting the RBA. As far as I know it is not a documented process (outside of IBM), but several of my clients have done it under the direction of IBM.



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 3:20 PM
To: [login to unmask email]
Subject: [DB2-L] the end of the world - or at least log sequence #



I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year



Can someone point me to documentation that discusses our options – or even better yet – share those options here?



1. Update resume?

2. Employ datasharing? (this has been on our table for years, but keeps getting pushed back)

3. Update copy of resume?



Thanks



Chris Hoelscher




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

________________________________

Introducing IBM® DB2® 10 for z/OS < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Philip Sevetson

Re: the end of the world - or at least log sequence #
(in response to David Simpson)
Chris, you're still using RBA log addressing, right? How fast are they filling up - if you reset the RBAs would it be a long time or a short time before they had to do it again?

Log Recovery Sequence Numbers give you a lot more years, so datasharing is a viable solution - done at one place I worked though not for that reason.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 4:20 PM
To: [login to unmask email]
Subject: [DB2-L] the end of the world - or at least log sequence #

I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year

Can someone point me to documentation that discusses our options - or even better yet - share those options here?

1. Update resume?
2. Employ datasharing? (this has been on our table for years, but keeps getting pushed back)
3. Update copy of resume?

Thanks

Chris Hoelscher


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Leon Katsnelson

Re: the end of the world - or at least log sequence #
(in response to Philip Sevetson)
Definitely go to data sharing and you will be good till 2042 for RBA/LRSN.
After that you will have to work on updating your resume but it will be
very impressive by then.

Leon Katsnelson
Program Director, IBM Data Servers



From: Chris Hoelscher <[login to unmask email]>
To: [login to unmask email]
Date: 2011/02/01 04:20 PM
Subject: [DB2-L] the end of the world - or at least log sequence #
Sent by: IDUG DB2-L <[login to unmask email]>



I have been informed that, based upon current consumption, one subsystem
will exhaust its log sequence numbers in just over one year

Can someone point me to documentation that discusses our options – or even
better yet – share those options here?

1. Update resume?
2. Employ datasharing? (this has been on our table for years, but
keeps getting pushed back)
3. Update copy of resume?

Thanks

Chris Hoelscher


The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender and
delete or destroy the material/information.


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Chris Hoelscher

Re: the end of the world - or at least log sequence #
(in response to Leon Katsnelson)
What I was told … they have never been reset in anyone’s memory – so if they were reset – it might 15+ years to fill up again …..



From: IDUG DB2-L [mailto:[login to unmask email]
Sent: Tuesday, February 01, 2011 4:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] the end of the world - or at least log sequence #

Chris, you’re still using RBA log addressing, right? How fast are they filling up – if you reset the RBAs would it be a long time or a short time before they had to do it again?

Log Recovery Sequence Numbers give you a lot more years, so datasharing is a viable solution – done at one place I worked though not for that reason.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 4:20 PM
To: [login to unmask email]
Subject: [DB2-L] the end of the world - or at least log sequence #

I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year

Can someone point me to documentation that discusses our options – or even better yet – share those options here?

1. Update resume?
2. Employ datasharing? (this has been on our table for years, but keeps getting pushed back)
3. Update copy of resume?

Thanks

Chris Hoelscher


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
________________________________

[Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Isaac Yassin

Re: the end of the world - or at least log sequence #
(in response to Chris Hoelscher)
Hi,

Even in DS the RBA of the OLD subsystem continues to go up.

You’ll need to retire the OLD subsystem (easier to do on DS).

The V9 manuals have the needed info.

Look at my ALT presentation for IDUG EMEA EU 2010 the section “Living at the end of time” foils 42-53



Isaac Yassin
IBM Gold Consultant

IBM Information Champion
IBM Certified Solution Expert
IBM Certified Database Administrator - DB2 for z/OS V7, V8, 9 & 10
IDUG Israel RUG

Attend IDUG 2011 - North America, the premiere event for DB2 professionals.
May 2-6, 2011 - Anaheim, California
Learn more at http://www.idug.org < http://www.idug.org/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Wednesday, February 02, 2011 3:54 AM
To: [login to unmask email]
Subject: Re: [DB2-L] the end of the world - or at least log sequence #



What I was told … they have never been reset in anyone’s memory – so if they were reset – it might 15+ years to fill up again …..







From: IDUG DB2-L [mailto:[login to unmask email]
Sent: Tuesday, February 01, 2011 4:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] the end of the world - or at least log sequence #



Chris, you’re still using RBA log addressing, right? How fast are they filling up – if you reset the RBAs would it be a long time or a short time before they had to do it again?



Log Recovery Sequence Numbers give you a lot more years, so datasharing is a viable solution – done at one place I worked though not for that reason.



_____

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 4:20 PM
To: [login to unmask email]
Subject: [DB2-L] the end of the world - or at least log sequence #



I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year



Can someone point me to documentation that discusses our options – or even better yet – share those options here?



1. Update resume?

2. Employ datasharing? (this has been on our table for years, but keeps getting pushed back)

3. Update copy of resume?



Thanks



Chris Hoelscher




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBM® DB2® 10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBM® DB2® 10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBM® DB2® 10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____

I am using the Free version of SPAMfighter < http://www.spamfighter.com/len > .
SPAMfighter has removed 248 of my spam emails to date.

Do you have a slow PC? < http://www.spamfighter.com/SLOW-PCfighter?cid=sigen > Try free scan!

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

  • import1 (16.5k)

Philip Sevetson

Re: the end of the world - or at least log sequence #
(in response to Isaac Yassin)
A better way to answer that question might occur to the student of differential calculus. Rather than taking the average rate of change over the entire fifteen years of the subsystem, you might want to compare the RBA's on the system a week or a month apart, and extrapolate that rate to see how fast RBA's would max-out from a zero-start at the _current_ rate of change :-)

--Phil, a math major back in the day

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 8:54 PM
To: [login to unmask email]
Subject: Re: [DB2-L] the end of the world - or at least log sequence #

What I was told ... they have never been reset in anyone's memory - so if they were reset - it might 15+ years to fill up again .....



From: IDUG DB2-L [mailto:[login to unmask email]
Sent: Tuesday, February 01, 2011 4:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] the end of the world - or at least log sequence #

Chris, you're still using RBA log addressing, right? How fast are they filling up - if you reset the RBAs would it be a long time or a short time before they had to do it again?

Log Recovery Sequence Numbers give you a lot more years, so datasharing is a viable solution - done at one place I worked though not for that reason.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Tuesday, February 01, 2011 4:20 PM
To: [login to unmask email]
Subject: [DB2-L] the end of the world - or at least log sequence #

I have been informed that, based upon current consumption, one subsystem will exhaust its log sequence numbers in just over one year

Can someone point me to documentation that discusses our options - or even better yet - share those options here?

1. Update resume?
2. Employ datasharing? (this has been on our table for years, but keeps getting pushed back)
3. Update copy of resume?

Thanks

Chris Hoelscher


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* 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