VIEW: SYS.DBA_TSM_DESTINATION

Source

View Text - Preformatted

SELECT
  src_db_name,
  dst_db_name,
  dst_inst_name,
  dst_inst_id,
  dst_inst_start_time,
  sequence#,
  dst_sid,
  dst_serial#,
  dst_start_time,
  dst_end_time,
  u1.name,
  u2.name,
  decode(dst_state,
          0,  'NONE',
          1,  'SELECTED',
          2,  'COMMITED SELECT',
          3,  'READY FOR PREPARE',
          4,  'PREPARED',
          5,  'READY FOR SWITCH',
          6,  'SWITCHED',
          7,  'FAILED',
          8,  'READY FOR STATE TRANSFER',
          9,  'IN STATE TRANSFER',
          10, 'END OF STATE TRANSFER',
          'UNKNOWN')
FROM tsm_dst$, user$ u1, user$ u2
WHERE
     (dst_userid   = u1.user#)
 AND (dst_schemaid = u2.user#)

View Text - HTML Formatted

SELECT SRC_DB_NAME
, DST_DB_NAME
, DST_INST_NAME
, DST_INST_ID
, DST_INST_START_TIME
, SEQUENCE#
, DST_SID
, DST_SERIAL#
, DST_START_TIME
, DST_END_TIME
, U1.NAME
, U2.NAME
, DECODE(DST_STATE
, 0
, 'NONE'
, 1
, 'SELECTED'
, 2
, 'COMMITED SELECT'
, 3
, 'READY FOR PREPARE'
, 4
, 'PREPARED'
, 5
, 'READY FOR SWITCH'
, 6
, 'SWITCHED'
, 7
, 'FAILED'
, 8
, 'READY FOR STATE TRANSFER'
, 9
, 'IN STATE TRANSFER'
, 10
, 'END OF STATE TRANSFER'
, 'UNKNOWN') FROM TSM_DST$
, USER$ U1
, USER$ U2 WHERE (DST_USERID = U1.USER#)
AND (DST_SCHEMAID = U2.USER#)