Resolution:
Description:
============
If for some reason you have a table definition on the MetaStor (Seg0) that points to data on another segment and that data segment does not exist the system will not let you delete the table definition unless it can also delete the data on the non-existant segment.
Environment:
============
Any Object Service Broker Database.
Symptoms:
=========
The delete fails with messages indicating segment cannot be accessed
Cause:
======
This is an integrity safeguard in case the data segment is just offline. I.e. you cannot delete the table definition umless you can also delete the data.
Resolution:
===========
The easiest way is

1) Redefine the missing segment, it doesn't have to be big.
2)  Run S6BBRSET to put root pages for the tables defined as on that segment back in the segment.
3) Delete the tables.
4) Remove the segment again.