Analysis:

An attempt was made to access a table where one of its objects is not accessible. The table may not be accessible because of one of the following reasons:

*  The table had NOT LOGGED INITIALLY activated when the unit of work was rolled back.

*  The table is a partitioned created temporary table or declared temporary table and one or more database partitions failed since the temporary table was instantiated or declared.

*  ROLLFORWARD encountered the activation of NOT LOGGED INITIALLY on this table or a NONRECOVERABLE load on this table.

Access to this table is not allowed because its integrity cannot be guaranteed.

One of the following actions can be taken.

*  If the object is a table and it had NOT LOGGED INITIALLY activated, drop the table. If this table is required, re-create it.

*  If the object is a data partition, detach it from the table. If this data partition is required, add a new one.

*  If the object is a non-partitioned index, drop the index. If this index is required, create a new one.

*  If the table is a created temporary table, disconnect from the server and connect again to instantiate a new copy of the created temporary table.

*  If the table is a declared temporary table, drop the table. If this table is required, declare it again.

*  Otherwise, restore from a table space or database backup. The backup image must have been taken subsequent to the commit point following the completion of the non-recoverable operation (NOT LOGGED INITIALLY operation, or NONRECOVERABLE load).

The catalogs and administrative views can be used to determine what the object is. To determine if the object is a table, use the following

query:

SELECT TABNAME

  FROM SYSCAT.TABLES

  WHERE TBSPACEID="<tbspace-id>" AND

    TABLEID="<object-id>"

If a table name does not appear as the result for this query you can determine if the object is a partition by using the following query:

SELECT DATAPARTITIONNAME, TABNAME

  FROM SYSCAT.DATAPARTITIONS

  WHERE TBSPACEID="<tbspace-id>" AND

    PARTITIONOBJECTID="<object-id>"

To determine if the object is an index, use the following query:

SELECT INDNAME

  FROM SYSCAT.INDEXES

  WHERE TBSPACEID="<tbspace-id>" AND

    INDEX_OBJECTID="<object-id>"

To determine if the object is a created temporary table or a declared temporary table, use the following query:

SELECT TABNAME

FROM SYSIBMADM.ADMINTEMPTABLES

WHERE TBSP_ID="<tbspace-id>" AND

  INDEX_TAB_FILE_ID="<object-id>"

sqlcode: -1477

sqlstate: 55019

   Related information:

   ADMINTEMPTABLES administrative view and ADMIN_GET_TEMP_TABLES table

   function - Retrieve information for temporary tables