topic SAS SPD Cluster table in SAS Programming

SAS SPD Cluster table

mjack — Wed, 21 Aug 2013 10:13:01 GMT

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

Re: SAS SPD Cluster table

mjack — Sun, 25 Aug 2013 19:47:00 GMT

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

Re: SAS SPD Cluster table

LinusH — Mon, 26 Aug 2013 06:30:10 GMT

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