zOS v7 DBD re-use problem

Brian Bear

zOS v7 DBD re-use problem
Hi Listers.

In trying to create a table specifying OBID 142. SQLCODE = -736, ERROR:
INVALID OBID 140 SPECIFIED results.

CREATE TABLE CHARM.TDIST23_PUSH_XREFB
LIKE CHARM.TDIST23_PUSH_XREF
IN DDIST01.SDIST123
OBID 140


Listing all the OBIDs, PSIDs and ISOBIDs from SYSTABLESPACE, SYSTABLES,
and SYSINDEXES shows no object using 142.

I have tried STOP/START the database and even recycled the entire
subsystem hoping it was merely the DBD still referring to the OBID. **
No good.

The SQLCODE -736 reads: ...select a different OBID for non-ROSHARE READ
database tables. TELL ME IT AIN'T SO!!

Is there anyway I can reclaim previously used OBIDs?

Thanks in advance.

bb

*****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

---------------------------------------------------------------------------------
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

Richard Fazio

Re: zOS v7 DBD re-use problem
(in response to Brian Bear)
I'm not sure about the reclaiming bit. However, you may want to check
if the DBD is ok.

Run REPAIR DBD TEST DATABASE DDIST01

Just a thought,
faz

Rich Fazio
Information Architecture

TransUnion, LLC
Marketing Services, 8th Floor
555 West Adams St. Chicago, IL 60661
Phone (312) 985-3270 Fax (312) 466-6453

Talk to teach - Listen to learn


>>> [login to unmask email] 2005-12-21 2:01:45 PM >>>


Hi Listers.

In trying to create a table specifying OBID 142. SQLCODE = -736,
ERROR: INVALID OBID 140 SPECIFIED results.

CREATE TABLE CHARM.TDIST23_PUSH_XREFB
LIKE CHARM.TDIST23_PUSH_XREF
IN DDIST01.SDIST123
OBID 140


Listing all the OBIDs, PSIDs and ISOBIDs from SYSTABLESPACE, SYSTABLES,
and SYSINDEXES shows no object using 142.

I have tried STOP/START the database and even recycled the entire
subsystem hoping it was merely the DBD still referring to the OBID.
** No good.

The SQLCODE -736 reads: ...select a different OBID for non-ROSHARE
READ database tables. TELL ME IT AIN'T SO!!

Is there anyway I can reclaim previously used OBIDs?

Thanks in advance.

bb
*****************************************************************************
The information transmitted is intended only for the person or entity
to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of,
or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

---------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------
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

[login to unmask email]

Re: zOS v7 DBD re-use problem
(in response to Richard Fazio)
Brian,

Well, the syntax description for Create Table ha this caveat:

The integer must not identify an existing or
previously used OBID of the database.

So, I think you're out of luck :)


Lock Lyon
Compuware Corp





Hi Listers.

In trying to create a table specifying OBID 142. SQLCODE = -736, ERROR:
INVALID OBID 140 SPECIFIED results.

CREATE TABLE CHARM.TDIST23_PUSH_XREFB
LIKE CHARM.TDIST23_PUSH_XREF
IN DDIST01.SDIST123
OBID 140


Listing all the OBIDs, PSIDs and ISOBIDs from SYSTABLESPACE, SYSTABLES,
and SYSINDEXES shows no object using 142.

I have tried STOP/START the database and even recycled the entire
subsystem hoping it was merely the DBD still referring to the OBID. **
No good.

The SQLCODE -736 reads: ...select a different OBID for non-ROSHARE READ
database tables. TELL ME IT AIN'T SO!!

Is there anyway I can reclaim previously used OBIDs?

Thanks in advance.

bb


---------------------------------------------------------------------------------
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

Colleen Clow

Re: zOS v7 DBD re-use problem
(in response to Wayne Driscoll)
Could just be a typo in your email, but which OBID are you trying to create...140 or
142? If you're really trying to create 142, then your create statement has the wrong OBID in it and that may change your result.

ssv

Brian Bear <[login to unmask email]> wrote:

Hi Listers.

In trying to create a table specifying OBID 142. SQLCODE = -736, ERROR: INVALID OBID 140 SPECIFIED results.

CREATE TABLE CHARM.TDIST23_PUSH_XREFB
LIKE CHARM.TDIST23_PUSH_XREF
IN DDIST01.SDIST123
OBID 140


Listing all the OBIDs, PSIDs and ISOBIDs from SYSTABLESPACE, SYSTABLES, and SYSINDEXES shows no object using 142.

I have tried STOP/START the database and even recycled the entire subsystem hoping it was merely the DBD still referring to the OBID. ** No good.

The SQLCODE -736 reads: ...select a different OBID for non-ROSHARE READ database tables. TELL ME IT AIN'T SO!!

Is there anyway I can reclaim previously used OBIDs?

Thanks in advance.

bb *****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

--------------------------------------------------------------------------------- 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


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
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

Wayne Driscoll

Re: zOS v7 DBD re-use problem
(in response to LL581@DAIMLERCHRYSLER.COM)
Brian,
The only way to get an OBID to be reused is if there are NO image copies
available that may contain rows for that table. What this means is that you
will need to:
1 - Take FULL image copies of all tablespaces in the database.
2 - Run a MODIFY RECOVERY to remove ALL older image copies from SYSUTIL

Then run the create. However, other than for the mentioned ROSHARE (which I
don't think is even supported), there really isn't a good reason to specify
the OBID for a table, so I would just remove that clause.
Hope this helps,
Wayne Driscoll
Product Developer
Western Metal Supply
NOTE: All opinions are strictly my own.


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Brian Bear
Sent: Wednesday, December 21, 2005 2:02 PM
To: [login to unmask email]
Subject: [DB2-L] zOS v7 DBD re-use problem



Hi Listers.

In trying to create a table specifying OBID 142. SQLCODE = -736, ERROR:
INVALID OBID 140 SPECIFIED results.

CREATE TABLE CHARM.TDIST23_PUSH_XREFB
LIKE CHARM.TDIST23_PUSH_XREF
IN DDIST01.SDIST123
OBID 140


Listing all the OBIDs, PSIDs and ISOBIDs from SYSTABLESPACE, SYSTABLES, and
SYSINDEXES shows no object using 142.

I have tried STOP/START the database and even recycled the entire subsystem
hoping it was merely the DBD still referring to the OBID. ** No good.

The SQLCODE -736 reads: ...select a different OBID for non-ROSHARE READ
database tables. TELL ME IT AIN'T SO!!

Is there anyway I can reclaim previously used OBIDs?

Thanks in advance.

bb
****************************************************************************
*
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
****************************************************************************
*

----------------------------------------------------------------------------
----- 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

---------------------------------------------------------------------------------
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