[TRAFODION-1644] 'initialize trafodion,drop' doesn't drop _DTM_ objects

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 2.0-incubating
• Component/s: db-utility-backup-restore, sql-general
• Assignee: Suresh Subbiah
• Reporter: Gao, Rui-Xian
• Created: 23/Nov/15 08:02
• Updated: 09/Dec/15 06:43
• Resolved: 09/Dec/15 06:43

Description

currently, 'initialize trafodion, drop' doesn't drop all TRAFODION objects, we need cleanup DTM objects from hbase shell.

>>initialize trafodion, drop;

— SQL operation complete.

hbase(main):002:0> list 'TRAFODION.*'
TABLE
TRAFODION.DTM.TLOG0_CONTROL_POINT
TRAFODION.DTM.TLOG0_LOG_0
TRAFODION.DTM.TLOG0_LOG_1
TRAFODION.DTM.TLOG0_LOG_2
TRAFODION.DTM.TLOG0_LOG_3
TRAFODION.DTM.TLOG0_LOG_4
TRAFODION.DTM.TLOG0_LOG_5
TRAFODION.DTM.TLOG0_LOG_6
TRAFODION.DTM.TLOG0_LOG_7
TRAFODION.DTM.TLOG0_LOG_8
TRAFODION.DTM.TLOG0_LOG_9
TRAFODION.DTM.TLOG0_LOG_a
TRAFODION.DTM.TLOG0_LOG_b
TRAFODION.DTM.TLOG0_LOG_c
TRAFODION.DTM.TLOG0_LOG_d
TRAFODION.DTM.TLOG0_LOG_e
TRAFODION.DTM.TLOG0_LOG_f
TRAFODION.DTM.TLOG1_CONTROL_POINT
TRAFODION.DTM.TLOG1_LOG_0
TRAFODION.DTM.TLOG1_LOG_1
TRAFODION.DTM.TLOG1_LOG_2
TRAFODION.DTM.TLOG1_LOG_3
TRAFODION.DTM.TLOG1_LOG_4
TRAFODION.DTM.TLOG1_LOG_5
TRAFODION.DTM.TLOG1_LOG_6
TRAFODION.DTM.TLOG1_LOG_7
TRAFODION.DTM.TLOG1_LOG_8
TRAFODION.DTM.TLOG1_LOG_9
TRAFODION.DTM.TLOG1_LOG_a
TRAFODION.DTM.TLOG1_LOG_b
TRAFODION.DTM.TLOG1_LOG_c
TRAFODION.DTM.TLOG1_LOG_d
TRAFODION.DTM.TLOG1_LOG_e
TRAFODION.DTM.TLOG1_LOG_f
TRAFODION.DTM.TLOG2_CONTROL_POINT
TRAFODION.DTM.TLOG2_LOG_0
TRAFODION.DTM.TLOG2_LOG_1
TRAFODION.DTM.TLOG2_LOG_2
TRAFODION.DTM.TLOG2_LOG_3
TRAFODION.DTM.TLOG2_LOG_4
TRAFODION.DTM.TLOG2_LOG_5
TRAFODION.DTM.TLOG2_LOG_6
TRAFODION.DTM.TLOG2_LOG_7
TRAFODION.DTM.TLOG2_LOG_8
TRAFODION.DTM.TLOG2_LOG_9
TRAFODION.DTM.TLOG2_LOG_a
TRAFODION.DTM.TLOG2_LOG_b
TRAFODION.DTM.TLOG2_LOG_c
TRAFODION.DTM.TLOG2_LOG_d
TRAFODION.DTM.TLOG2_LOG_e
TRAFODION.DTM.TLOG2_LOG_f
51 row(s) in 0.0320 seconds

=> ["TRAFODION._DTM_.TLOG0_CONTROL_POINT", "TRAFODION._DTM_.TLOG0_LOG_0", "TRAFODION._DTM_.TLOG0_LOG_1", "TRAFODION._DTM_.TLOG0_LOG_2", "TRAFODION._DTM_.TLOG0_LOG_3", "TRAFODION._DTM_.TLOG0_LOG_4", "TRAFODION._DTM_.TLOG0_LOG_5", "TRAFODION._DTM_.TLOG0_LOG_6", "TRAFODION._DTM_.TLOG0_LOG_7", "TRAFODION._DTM_.TLOG0_LOG_8", "TRAFODION._DTM_.TLOG0_LOG_9", "TRAFODION._DTM_.TLOG0_LOG_a", "TRAFODION._DTM_.TLOG0_LOG_b", "TRAFODION._DTM_.TLOG0_LOG_c", "TRAFODION._DTM_.TLOG0_LOG_d", "TRAFODION._DTM_.TLOG0_LOG_e", "TRAFODION._DTM_.TLOG0_LOG_f", "TRAFODION._DTM_.TLOG1_CONTROL_POINT", "TRAFODION._DTM_.TLOG1_LOG_0", "TRAFODION._DTM_.TLOG1_LOG_1", "TRAFODION._DTM_.TLOG1_LOG_2", "TRAFODION._DTM_.TLOG1_LOG_3", "TRAFODION._DTM_.TLOG1_LOG_4", "TRAFODION._DTM_.TLOG1_LOG_5", "TRAFODION._DTM_.TLOG1_LOG_6", "TRAFODION._DTM_.TLOG1_LOG_7", "TRAFODION._DTM_.TLOG1_LOG_8", "TRAFODION._DTM_.TLOG1_LOG_9", "TRAFODION._DTM_.TLOG1_LOG_a", "TRAFODION._DTM_.TLOG1_LOG_b", "TRAFODION._DTM_.TLOG1_LOG_c", "TRAFODION._DTM_.TLOG1_LOG_d", "TRAFODION._DTM_.TLOG1_LOG_e", "TRAFODION._DTM_.TLOG1_LOG_f", "TRAFODION._DTM_.TLOG2_CONTROL_POINT", "TRAFODION._DTM_.TLOG2_LOG_0", "TRAFODION._DTM_.TLOG2_LOG_1", "TRAFODION._DTM_.TLOG2_LOG_2", "TRAFODION._DTM_.TLOG2_LOG_3", "TRAFODION._DTM_.TLOG2_LOG_4", "TRAFODION._DTM_.TLOG2_LOG_5", "TRAFODION._DTM_.TLOG2_LOG_6", "TRAFODION._DTM_.TLOG2_LOG_7", "TRAFODION._DTM_.TLOG2_LOG_8", "TRAFODION._DTM_.TLOG2_LOG_9", "TRAFODION._DTM_.TLOG2_LOG_a", "TRAFODION._DTM_.TLOG2_LOG_b", "TRAFODION._DTM_.TLOG2_LOG_c", "TRAFODION._DTM_.TLOG2_LOG_d", "TRAFODION._DTM_.TLOG2_LOG_e", "TRAFODION._DTM_.TLOG2_LOG_f"]