Re-using OBID's in DB2 on Z/OS

A (Astrid) Slegtenhorst

Re-using OBID's in DB2 on Z/OS
Hi,

In order to setup a procedure for quick data-replication we need to specify OBID's during table creation. This is possible with the OBID option in the CREATE TABLE statement. According to the SQL Reference, The OBID specified should not exist and should not have been used previously.

And that is where our problem lies, we need to specify OBID's that do not exist anymore but have existed in the past.
Does anyone know if there is a way to re-use OBID's of objects that have been dropped ?

Thanks,

Astrid Slegtenhorst
Rabobank
The Netherlands






De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Sally Mir

Re: Re-using OBID's in DB2 on Z/OS
(in response to A (Astrid) Slegtenhorst)
If the OBID you want to reuse belongs to a table that has been dropped, you
must first REORG the tablespace that contained the dropped table to remove
all traces of that OBID, then MODIFY RECOVERY to eliminate any image copies
that could be used to recover the tablespace to an image that contained
that OBID. Once all traces of the OBID are removed, it should be possible
to reuse it using the OBID clause on the CREATE TABLE statement.


Sally A. Mir, AVP
IBM Certified Database Administrator
DB2 Universal Database V8.1 for Z/OS
(336) 773-4011



"Slegtenhorst, A
(Astrid)"
<A.Slegtenhorst@R To
N.RABOBANK.NL> [login to unmask email]
Sent by: DB2 Data cc
Base Discussion
List Subject
<[login to unmask email] [DB2-L] Re-using OBID's in DB2 on
ORG> Z/OS


01/14/2005 03:29
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






Hi,


In order to setup a procedure for quick data-replication we need to specify
OBID's during table creation. This is possible with the OBID option in the
CREATE TABLE statement. According to the SQL Reference, The OBID specified
should not exist and should not have been used previously.


And that is where our problem lies, we need to specify OBID's that do not
exist anymore but have existed in the past.
Does anyone know if there is a way to re-use OBID's of objects that have
been dropped ?


Thanks,


Astrid Slegtenhorst
Rabobank
The Netherlands








De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
ForwardSourceID:NT0001F362

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

A (Astrid) Slegtenhorst

Re: Re-using OBID's in DB2 on Z/OS
(in response to Sally Mir)
Sally,

Appologies for the late reaction but thanks for your input. REORG/MODIFY works fine.

Regards,
Astrid Slegtenhorst

-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email]namens
[login to unmask email]
Verzonden: vrijdag 14 januari 2005 15:21
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] Re-using OBID's in DB2 on Z/OS


If the OBID you want to reuse belongs to a table that has been dropped, you
must first REORG the tablespace that contained the dropped table to remove
all traces of that OBID, then MODIFY RECOVERY to eliminate any image copies
that could be used to recover the tablespace to an image that contained
that OBID. Once all traces of the OBID are removed, it should be possible
to reuse it using the OBID clause on the CREATE TABLE statement.


Sally A. Mir, AVP
IBM Certified Database Administrator
DB2 Universal Database V8.1 for Z/OS
(336) 773-4011



"Slegtenhorst, A
(Astrid)"
<A.Slegtenhorst@R To
N.RABOBANK.NL> [login to unmask email]
Sent by: DB2 Data cc
Base Discussion
List Subject
<[login to unmask email] [DB2-L] Re-using OBID's in DB2 on
ORG> Z/OS


01/14/2005 03:29
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






Hi,


In order to setup a procedure for quick data-replication we need to specify
OBID's during table creation. This is possible with the OBID option in the
CREATE TABLE statement. According to the SQL Reference, The OBID specified
should not exist and should not have been used previously.


And that is where our problem lies, we need to specify OBID's that do not
exist anymore but have existed in the past.
Does anyone know if there is a way to re-use OBID's of objects that have
been dropped ?


Thanks,


Astrid Slegtenhorst
Rabobank
The Netherlands








De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
ForwardSourceID:NT0001F362

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm





De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm