zOS v7 DBD re-use problem - Fixed.

Brian Bear

zOS v7 DBD re-use problem - Fixed.
Thanks to all who replied.

The discrepancy in the OBIDs in my post (140 and 142) was just a typo.
(thanks Colleen).

I ran REPAIR DBD TEST earlier this morning and it reported minor problems
that IBM requested I run REBUILD. Once I did it worked. You nailed the
cause, faz.

Just as an FYI and for those who are interested, I am copying (ADRDSSU)
the VSAM datasets from our prod subsystem to a test subsystem (changing
the high level qual) in order to copy prod data into our test region to
avoid the laborious unload/load process. To get this to work, the table
OBID's need to be the same, hence the reason I need to specify the OBID in
the CREATE TABLE statement.

Regards and thanks to all who responded.

bb





Richard Fazio <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/21/2005 03:11 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] zOS v7 DBD re-use problem






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

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