-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