Whether the Maximum Number of Indexed Columns Has Been Reached

Whether the maximum number of indexed columns has been reached

The number of indexed columns to be migrated in the source database cannot exceed 32.

Failure cause: The number of indexed columns to be migrated in the source database cannot exceed 32.

Handling suggestion: Check the number of indexed columns in the source table and modify the indexes.

Statement for viewing indexed columns:

SELECT T1.INDNAME ,T1.COLNAMES FROM  SYSCAT.INDEXES AS T1 JOIN SYSCAT.INDEXCOLUSE AS T2 ON T1.INDNAME= T2.INDNAME WHERE  T1. TABNAME='table_name' AND T1. INDNAME= 'index_name';

Statement for deleting an index:

DROP INDEX index_name;

Statement for creating an index:

CREATE INDEX index_name ON table_name(col1,col2);