SAS SPD Cluster table

Reply
Contributor
Posts: 42

SAS SPD Cluster table

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?   Smiley Sad

Please help Smiley Sad

Contributor
Posts: 42

Re: SAS SPD Cluster table

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

Super User
Posts: 5,424

Re: SAS SPD Cluster table

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...

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 393 views
  • 0 likes
  • 2 in conversation