Q
Problem solve Get help with specific problems with your technologies, process and projects.

Freeing up OBIDs

We're running DB2v6 on z/OS 1.4. We often create and drop a lot of objects so we get SQLCODE -497 saying that limit of 32k OBIDs has been exceeded. It seems that DB2 does not automatically free OBIDs after drop of objects so our DBA has to do REORG and MODIFY to reclaim unused OBIDs.

It's very inconvenient and time-consuming. Is it just the way it works or are we missing something (PTFs)?

Well, actually the OBID is still technically "in use." The MODIFY gets rid of image copy references that apply to the object in question. If an image copy reference remains in the DB2 Catalog, then DB2 considers the OBID still in use. Your DBA is doing things properly to free up OBIDs when you reach the limit.

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.

This was last published in December 2003

Dig Deeper on IBM DB2 management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close