Reset DB2 log RBA to zero

Doron Geva

Reset DB2 log RBA to zero
Hi

Does anyone have the experience to reset the db2 log RBA back to zero?
The site I work in has about two years at the most before we will reach the
log's end.
We are not in data sharing and we in DB2 V7 going to V8 so the process to
reset the log will be in DB2 V8

--
Best Regards

Doron Geva

Email: [login to unmask email]

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: Reset DB2 log RBA to zero
(in response to Doron Geva)
You need to talk to IBM - this is nowhere near as simple as it sounds

Part of the problem is that DB2 doesn't "trust" any data that has been created with a HIGHER rba/lrsn than the current high water mark

SO, if you do reset DB2 back to rba zero, a LOT of your data will be immediately inaccessible!!

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Doron Geva
Sent: Sat 20/12/2008 22:59
To: [login to unmask email]
Subject: [DB2-L] Reset DB2 log RBA to zero


Hi

Does anyone have the experience to reset the db2 log RBA back to zero?
The site I work in has about two years at the most before we will reach the log's end.
We are not in data sharing and we in DB2 V7 going to V8 so the process to reset the log will be in DB2 V8

--
Best Regards

Doron Geva

Email: [login to unmask email]


________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Charles Valentin

Re: Reset DB2 log RBA to zero
(in response to Phil Grainger)
Yes, we've been thru this process several times & IBM has a procedure to
follow.
This is not something you should try on your own....

Regards,
Charles Valentin
Verizon
=======
In a message dated 12/21/2008 9:31:40 A.M. Eastern Standard Time,
[login to unmask email] writes:

You need to talk to IBM - this is nowhere near as simple as it sounds

Part of the problem is that DB2 doesn't "trust" any data that has been
created with a HIGHER rba/lrsn than the current high water mark

SO, if you do reset DB2 back to rba zero, a LOT of your data will be
immediately inaccessible!!

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Doron Geva
Sent: Sat 20/12/2008 22:59
To: [login to unmask email]
Subject: [DB2-L] Reset DB2 log RBA to zero


Hi

Does anyone have the experience to reset the db2 log RBA back to zero?
The site I work in has about two years at the most before we will reach the
log's end.
We are not in data sharing and we in DB2 V7 going to V8 so the process to
reset the log will be in DB2 V8

--
Best Regards

Doron Geva

Email: [login to unmask email]


________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site, you can also access
the IDUG Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information < http://www.idug.org/lsconf > , and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest IDUG
conference information and much more. If you have not yet signed up for Basic
Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms

**************One site keeps you connected to all your email: AOL Mail,
Gmail, and Yahoo Mail. Try it now.
(http://www.aol.com/?optin=new-dp&icid=aolcom40vanity&ncid=emlcntaolcom00000025)

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Douwe van Sluis

Re: Reset DB2 log RBA to zero
(in response to Charles Valentin)
Time to talk to IBM. No easy task that can be done on a Sunday
afternoon.
Take a look at Willies Blog also
http://it.toolbox.com/blogs/db2zos/can-your-db2-for-zos-subsystem-run-ou
t-of-log-rbas-28822

Vriendelijke groet,
Douwe van Sluis


-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Doron Geva
Verzonden: zaterdag 20 december 2008 23:59
Aan: [login to unmask email]
Onderwerp: [DB2-L] Reset DB2 log RBA to zero


Hi

Does anyone have the experience to reset the db2 log RBA back to zero?
The site I work in has about two years at the most before we will reach
the log's end.
We are not in data sharing and we in DB2 V7 going to V8 so the process
to reset the log will be in DB2 V8

--
Best Regards

Doron Geva

Email: [login to unmask email]


_____


< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 *
Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
< http://www.idug.org/lsms > Services


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms