[SQL0601] INDEX_<index name> in <C&DS Lib> type *FILE already exists
Attempts to run CLISETUP fail with the following errors:
java.sql.SQLException: [SQL0601] <index name> in <C&DS Lib> *FILE already exists.
A C&DS 4.0 database was restored into a new database/schema for C&DS 4.2.1. The restored indexes still pointed to the C&DS 4.0 library, and were not rebuilt.
Collaboration and Deployment Services 4.0 and 4.2.1
Diagnosing the problem
Review the setup.log
Resolving the problem
Delete the indexes from the C&DS 4.2.1 library with the following steps:
WRKOBJ OBJ(<C&DS4.2.1 Lib>/UQ*) - then take option 4 to delete these indexes
WRKOBJ OBJ(<C&DS4.2.1 Lib>/INDEX*) - then take option 4 to delete these