R: [DB2-L] Forward log recovery for a dropped table

Aldo Tomassi

R: [DB2-L] Forward log recovery for a dropped table
Thank you all,
Using DDL Mapping File, yesterday I've recovered the six lost log records.
Now I can drop table VTTAB075 again...in the right environment, don't
worry!!!

Aldo Tomassi
___________________________________________________
Cell.: +39-340-9647426
e-mail: [login to unmask email]

______________________________________________________________________



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

______________________________________________________________________

* 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

Steen Rasmussen

Re: R: [DB2-L] Forward log recovery for a dropped table
(in response to Aldo Tomassi)
Sounds good Aldo - glad to hear you are back alive.
If you end up in the same situation (dropping the wrong table), remember
you can specify the OBID xxx on the create table statement so your "new"
table has the same internal ID's - this will make your like a little
easier. However - if the tablespace is dropped you might not get the
same PSID and then the scenario is different again.

Steen Rasmussen
CA
Sr Engineering Services Architect


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Tomassi, Aldo
Sent: Friday, November 28, 2008 6:03 AM
To: [login to unmask email]
Subject: [DB2-L] R: [DB2-L] Forward log recovery for a dropped table

Thank you all,
Using DDL Mapping File, yesterday I've recovered the six lost log
records.
Now I can drop table VTTAB075 again...in the right environment, don't
worry!!!

Aldo Tomassi
____________

______________________________________________________________________

* 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

Wayne Driscoll

Re: Forward log recovery for a dropped table
(in response to Steen Rasmussen)
Peter,
For a huge number of reasons, including integrity the OBID option of
CREATE TABLE can only be used to assign an OBID that is not currently in
use in the given database. A DROP TABLE is not enough to "free" an OBID
from the DBD. In order to free an OBID, either the TABLESPACE must be
dropped, or the TABLESPACE must be REORGED and then all SYSCOPY rows for
the TABLESPACE containing the table must be removed via MODIFY RECOVERY.
As long as an image copy exists in the catalog that could contain rows
from that table, the OBD for the table will still remain in the DBD.

=======================
Wayne Driscoll
Omegamon DB2 L3 Support/Development
wdrisco(AT)us.ibm.com
=======================



Peter Vanroose <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
11/27/2008 03:20 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Forward log recovery for a dropped table






Or you could have (re)created the table to have the same OBID as the
dropped
one, by using the OBID option of CREATE TABLE.

-- Peter Vanroose.

______________________________________________________________________

* 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


______________________________________________________________________

* 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