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
does anybody know where should I post this question to get the answer ?
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...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.