Convert a Test&Dev DB from K-Safe=1 to K-Safe=0
Only for a big data specific test I need to temporaneously make space in the system and eliminate data redundancy. My question is regarding the process to move from K-safe=1 to K-safe=0. For example i have a base table named "fact_data" and 4 nodes, so 4 segments: node001 -> superprojection segment fact_data_b0, buddy on node002 -> fact_data_b1 (size are similar but not exactly the same) node002 -> fact_data_b0, buddy on node003 -> fact_data_b1 node003 -> fact_data_b0, buddy on node004 -> fact_data_b1 node004 -> fact_data_b0, buddy on node001 -> fact_data_b1 Is enough to drop buddy projection fact_data_b1 and MARK_DESIGN_KSAFE(0)? any other system parameter to setup? Reverse process will be recreate projections with OFFSET value and refresh. Many thanks in advance.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.