-747   TABLE table-name IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED

Explanation

An attempt was made to access or reference a table with one or more LOB columns, however either
  • an auxiliary table for storing one of the LOB columns has not been created, or
  • an index has not been created for an auxiliary table, or
  • there is not an auxiliary table for each partition of the table space.

System action

The statement cannot be processed.

Programmer response

  • Use CREATE TABLESPACE to create a LOB table space.
  • Use CREATE TABLE to create the auxiliary table for storing the column.
  • Use CREATE INDEX to create an index on the auxiliary table.
  • Resubmit the statement that failed.

SQLSTATE

57054