Page 1 of 1

Unable to create DS_DATATYPES indices

Posted: Thu Nov 05, 2009 10:32 am
by attu
I am trying to build indices for DS_DATATYPES, but it is giving me errors.

Code: Select all

 
>DS.REINDEX DS_DATATYPES
************************************************************
* Re-indexing DataStage Repository file: DS_DATATYPES
File "DS_DATATYPES" has no indices.
File header block updated.
 
*    CATEGORY index
Unable to open "/datastage/capture0008016054aa1257437794" file.

>LIST.INDEX DS_DATATYPES INFORM
File "DS_DATATYPES" has no indices.

>SET.INDEX DS_DATATYPES INFORM
File DS_DATATYPES has no secondary indices.

How can I re-build the indices of DS_DATATYPES?

Posted: Thu Nov 05, 2009 2:15 pm
by ray.wurlod
Make sure that you have read, write and execute permission to the /datastage directory.

Posted: Thu Nov 05, 2009 3:37 pm
by attu
yes, we had some SAN issues on the /datastage file system and unable to write.
The issue was resolved after unmounting and remounting filesystem.

Thanks