08-21-2013 06:13 AM
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;
Is there any way that I can run successfully undo cluster..... ?
what should I do now?
08-26-2013 02:30 AM
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...