"S6BTH002E Table name not found in resident table index" produced on trying to access a table

"S6BTH002E Table name not found in resident table index" produced on trying to access a table

book

Article ID: KB0088968

calendar_today

Updated On:

Products Versions
TIBCO Object Service Broker for z/OS -
Not Applicable -

Description

Resolution:
Each segment in an OSB system has a list of tables in the segment called the resident table index (RTIX).
The MetaStor segment, also has a list of ALL tables.

This msg normally indicates the table is in the MetaStor RTIX but not in the user segment RTIX


Environment:
============
Any OSB/ObjectStar/TMI system where segments are moved/copied.

Symptoms:
=========
The msg in the abstract is produced when an attempt is made to access the table

Cause:
======
This is generally caused by restoring a version of the user segment prior to the table being created or restoring a version of the segment from another system which never contained the table.

Resolution:
===========
The problem can be resolved in several ways.

1) Restore a version of the segment that does contain the table, move the table to another segment, restore the segment without the table.

2) Run HRNBRSET on an empty version of the segment, move the table and then restore the segment.

3) Contact support and use the PAGEFIX utility to point at the table residing on a different segment.

Issue/Introduction

"S6BTH002E Table name not found in resident table index" produced on trying to access a table