-640   LOCKSIZE ROW CANNOT BE SPECIFIED BECAUSE TABLE IN THIS TABLESPACE HAS TYPE 1 INDEX

Explanation

If LOCKSIZE ROW is specified for a table space, all indexes on tables in the table space must be type 2 indexes. The following SQL statement identifies all the type 1 indexes:
SELECT I.CREATOR, I.NAME
FROM SYSIBM.SYSINDEXES I,
SYSIBM.SYSTABLES T
WHERE INDEXTYPE = ' '
AND T.TSNAME = 'table_space_name'
AND T.DBNAMe = 'database_name'
AND T.CREATOR = I.TBCREATOR
AND T.NAME = I.TBNAME;
where 'table_space_name' is the name of the table space that is to be altered; 'database_name' is the name of the database that contains the table space.

System action

The statement cannot be processed.

Programmer response

Since the LOCKSIZE ROW on the table space and the type 1 indexes conflict, either use the ALTER INDEX statement to convert all type 1 indexes to type 2 indexes or use another LOCKSIZE option.

SQLSTATE

56089