Ixutil commands on SAS spds Cluster tables

Question

Can indexes be reorganized of SAS SPDS Cluster tables? i.e. Can IXUTIL commands be run directly on SAS Cluster tables ( without unclustering first).

I tried running on the cluster tables with various alterations but so far only getting errors like:

• Segmentation fault
• Could not Reorg Index Index_name
• Could not open dataset dataset_name

This makes me think that probably IXUTIL commands are not made for SAS SPDS Cluster tables

When I uncluster the cluster table and run the IXUTIL commands on individual members, the commands run fine. I have searched a lot on the internet for clues, hints etc have not found a thing.

Answer 1

I checked all available versions of manuals for SAS SPDS. I also read through few technical notes trying to find any evidence that ixutil can be used on clustered tables (specifically dynamic clustered tables).

Nowhere it is stated that ixutil can not be used on dynamic clustered tables.

But, in all sections that talk about "Dynamic Clustered Tables", it is noted that there are very restricted number of operations that are allowed to be run on dynamic clustered tables: Creating a cluster, undoing a cluster, adding tables, listing tables. For any other operation, we need to first uncluster the tables.

I will add references if the above discussion seems relevant to you.