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...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.