-20106   THE CCSID FOR THE TABLE SPACE OR DATABASE CANNOT BE CHANGED BECAUSE THE TABLE SPACE OR DATABASE ALREADY CONTAINS A TABLE THAT IS REFERENCED IN EXISTING VIEW, OR MATERIALIZED QUERY TABLE DEFINITIONS OR AN EXTENDED INDEX

Explanation

An ALTER statement cannot be used to alter the CCSID for a table space or database that contains a table that is referenced in an existing view, or materialized query table definitions, or a table that already has an extended index.

System action

The statement cannot be processed.

Programmer response

To alter the CCSID for the specified space, complete the following steps:
  1. Drop any existing view or materialized query table definitions that refer to tables contained in the identified space.
  2. Drop all of the extended indexes created on the table.
  3. Reissue the ALTER statement.

SQLSTATE

42945