DB2 SQL-Error: -640
SQLState: 56089
Short Description: LOCKSIZE ROW CANNOT BE SPECIFIED BECAUSE TABLE IN THIS TABLESPACE HAS TYPE INDEX C E SQL S T P S LOCKSIZE ROW ALTER INDEX LOCKSIZE
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.