| |
- Causa
- LOCKSIZE ROW CANNOT BE SPECIFIED BECAUSE TABLE IN THIS TABLESPACE HAS TYPE 1 INDEX
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.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
