IBM Support

[SQL0601] INDEX_<index name> in <C&DS Lib> type *FILE already exists

Technote (troubleshooting)


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

Re-run clisetup

Related information

Need more help? Our C&DS forum is Live!

Document information

More support for: SPSS Collaboration and Deployment Services
Content Repository

Software version: 4.2.1

Operating system(s): IBM i

Reference #: 1644569

Modified date: 07 September 2016

Translate this page: