Admin>

@filename[.ext]

$ prs_adm
ProSync 4 - Admin Utility
TmaxData Corporation Copyright (c) 2008-. All rights reserved.

$ prs_adm
ProSync 4 - Admin Utility
TmaxData Corporation Copyright (c) 2008-. All rights reserved.  

Admin> HELP 

SET HIS[TORY] {n}

SET LINE[SIZE] {n}

SET NUM[WIDTH] {n}

SET PAGE[SIZE] {n}

SET PROM[PT] {prompt_string}

SET SUF[FIX] {extension}

Admin> ! dir *.ext
Admin> !

Admin> HOST dir *.ext
Admin> HOST

@ {filename}

Admin> @ run
Admin> @ run.sql

/

Admin> HELP
Admin> /

#동기화 테이블 추가/제거
ALTER inst_id {ADD|DEL[ETE]} TABLE table_owner.table_name GROUP=group_num

#Parameter 변경
ALTER inst_id {EXT|APP[LY]|LLOB} SET parameter='values'

EXIT | Q[UIT]

H[ELP] [topic]

Admin> HELP SET

PAUSE {inst_id}

Admin> PAUSE prosync4
prosync4 paused.

RESUME {inst_id}

Admin> RESUME prosync4
prosync4 resumed.

SET {parameter} {value}

Admin> SET HISTORY 100

SHO[W] ALL
SHO[W] PARAM[ETER] instance_id {EXT[RACT] num | APP[LY] num | LLOB} [parameter_name]
SHO[W] PARAM[ETER] AGE[NT] agent_id [parameter_name]

Admin> SHOW ALL

Admin> SHOW PARAM prosync4 EXT 1 LOG_LEVEL
Admin> SHOW PARAM prosync4 APPLY 1 MAP
Admin> SHOW PARAM prosync4 LLOB LLOB_FLASHBACK_ERROR

Admin> SHOW PARAM AGENT agent1

SHUTD[OWN] ALL
SHUTD[OWN] AGE[NT] [ABORT] [agent_id]
SHUTD[OWN] inst_id [EXT[RACT] [num] | APP[LY] [num]] [ABORT]

Admin> SHUTDOWN pro
*** Shutdown Process... [pro_ext1]
	Process 'pro_ext1' aborted.
*** Shutdown Process... [pro_apply1]
	Process 'pro_apply1' aborted.
*** Shutdown Process... [pro_llob]
	Process 'pro_llob' aborted.

Admin> SHUTDOWN AGENT agent1
*** Shutdown Agent Process... [agent1]
	Process 'prs_agent' aborted.

START[UP] ALL
START[UP] AGE[NT] agent_id
START[UP] inst_id [EXT[RACT] [num] | APP[LY] [num]]

Admin> STARTUP AGENT agent1
*** Startup Agent Process... [agent1]
	Process 'prs_agent' started.

Admin> STARTUP pro
*** Startup Process... [pro_ext1]
	Process 'pro_ext1' started.
*** Startup Process... [pro_apply1]
	Process 'pro_apply1' started.
*** Startup Process... [pro_llob]
	Process 'pro_llob' started.

STATUS
STATUS inst_id

Admin> STATUS
prs_agent ID: agent1, HOST: 192.168.51.45, PORT: 7600 is running
prs_agent ID: agent2, HOST: 192.168.51.54, PORT: 7601 is running
prs_agent ID: agent3, HOST: 192.168.51.55, PORT: 7602 is stopped

Instance ID: [prosync4]
prosync4_ext1 (1) is running (prs_mgr ID : agent1, HOST: 192.168.51.45, PORT: 7600)
prosync4_ext2 (2) is running (prs_mgr ID : agent1, HOST: 192.168.51.45, PORT: 7600)
prosync4_apply1 (1) is running (prs_mgr ID : agent2, HOST: 192.168.51.54, PORT: 7601)
prosync4_llob (1) is stopped (prs_mgr ID : agent1, HOST: 192.168.51.45, PORT: 7600)

Instance ID: [prosync3]
Agent Process for proc[Extract], num[1] is not running.
Agent Process for proc[Extract], num[2] is not running.
Agent Process for proc[Apply], num[1] is not running.
Agent Process for proc[LONG/LOB], num[1] is not running.
Agent Process for proc[Verify], num[1] is not running.

Admin> STATUS prosync4
prosync4_ext1 (20133) has 8 cores, started at 2020/09/09 15:44:19
  + control thread, running
  + worker thread, running
  + sam thread, recv waiting
  + read thread, recv waiting

prosync4_apply1 (20154) has 8 cores, started at 2020/09/09 15:44:19
  + control thread, running
  + replay thread, recv waiting
  + construct thread, recv waiting

prosync4_llob (20168) has 8 cores, started at 2020/09/09 15:44:19
  + control thread, running
  + long/lob thread, recv waiting

prosync4_vf, stopped

MON[ITOR] {inst_id}

Thread #0
sql_text:
DELETE FROM "TEST"."T33" WHERE "C1" = :"C1" AND "C2" = :"C2" AND 
"C3" = :"C3" AND "C4" = :"C4" AND "C5" = :"C5" AND "C6" = :"C6" 
AND "C7" = :"C7" AND "C8" = :"C8" AND "C9" = :"C9" AND "C10" = 
:"C10" AND "C11" = :"C11" AND "TIME" = :"TIME" AND ROWNUM = 1
sql_et: 0 (ms)

Thread #1
sql_text:
DELETE FROM "TEST"."T33" WHERE "C1" = :"C1" AND "C2" = :"C2" AND
"C3" = :"C3" AND "C4" = :"C4" AND "C5" = :"C5" AND "C6" = :"C6"
AND "C7" = :"C7" AND "C8" = :"C8" AND "C9" = :"C9" AND "C10" =
 :"C10" AND "C11" = :"C11" AND "TIME" = :"TIME" AND ROWNUM = 1
sql_et: 0 (ms)

Thread #2
sql_text:
UPDATE "TEST"."T31" SET "C2" = :"C2", "C3" = :"C3", "C9" = :"C9"
, "C10" = :"C10", "C11" = :"C11" WHERE "C1" = :"C1" AND "C2" = :
"C2" AND "C3" = :"C3" AND "C4" = :"C4" AND "C5" = :"C5" AND "C6"
= :"C6" AND "C7" = :"C7" AND "C8" = :"C8" AND "C9" = :"C9" AND 
"C10" = :"C10" AND "C11" = :"C11" AND "TIME" = :"TIME" AND ROWNUM
 = 1
sql_et: 0 (ms)

Thread #3
sql_text:
UPDATE "TEST"."T33" SET "C2" = :"C2", "C3" = :"C3", "C9" = :"C9"
, "C10" = :"C10", "C11" = :"C11" WHERE "C1" = :"C1" AND "C2" = :
"C2" AND "C3" = :"C3" AND "C4" = :"C4" AND "C5" = :"C5" AND "C6"
= :"C6" AND "C7" = :"C7" AND "C8" = :"C8" AND "C9" = :"C9" AND "
C10" = :"C10" AND "C11" = :"C11" AND "TIME" = :"TIME" AND ROWNUM
 = 1
sql_et: 0 (ms)

Admin> START AGENT agent1
*** Startup Agent Process... [agent1]
        Process 'prs_agent' started.

Admin> STARTUP prosync4
*** Startup Process... [prosync4_ext1]
        Process 'prosync4_ext1' started.
*** Startup Process... [prosync4_apply1]
        Process 'prosync4_apply1' started.
*** Startup Process... [prosync4_llob]
        Process 'prosync4_llob' started.

Admin> SHUTDOWN prosync4
*** Shutdown Process... [prosync4_ext1]
        Process 'prosync4_ext1' aborted.
*** Shutdown Process... [prosync4_apply1]
        Process 'prosync4_apply1' aborted.
*** Shutdown Process... [prosync4_llob]
        Process 'prosync4_llob' aborted.