SAS SPD Cluster table

[mjack]

Hi Experts,

IF a cluster member has been mistakenly deleted and is unrecoverable.
Now when I try to run 'UNDO CLUSTER' command....  it gives error 'ERROR: Unable to complete CLUSTER UNDO on table ..tablename..'

PROC SPDO LIBRARY = libname ;

SET ACLUSER adminsp;

CLUSTER UNDO tablename;

quit;

Is there any way that I can run successfully undo cluster.....   ?

what should I do now?  

Please help

[mjack]

does anybody know where should I post this question to get the answer ?

[LinusH]

So what you are saying is that you don't have any backups on the cluster?

Can't fins anything in the doc about repairing a cluster. You don't happen to be at SPDS 5.1 already? If so, you might want to try CLUSTER REPLACE or REMOVE.

As a last try, before contacting SAS tech support, would be try to recreate the deleted member physically in some way. Make sure that the mdf-file has the same name as the deleted one.

Good luck, and please post any achievements, it's an interesting situation...