data_migration
Normal
0
/

ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
TRANSNAME
Y
TRANSNAME
STATUS
Y
STATUS
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
STARTDATE
Y
STARTDATE
ENDDATE
Y
ENDDATE
LOGDATE
Y
LOGDATE
DEPDATE
Y
DEPDATE
REPLAYDATE
Y
REPLAYDATE
LOG_FIELD
Y
LOG_FIELD
EXECUTING_SERVER
N
EXECUTING_SERVER
EXECUTING_USER
N
EXECUTING_USER
CLIENT
N
CLIENT

ID_BATCH
Y
ID_BATCH
SEQ_NR
Y
SEQ_NR
LOGDATE
Y
LOGDATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
INPUT_BUFFER_ROWS
Y
INPUT_BUFFER_ROWS
OUTPUT_BUFFER_ROWS
Y
OUTPUT_BUFFER_ROWS

ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
LOGGING_OBJECT_TYPE
Y
LOGGING_OBJECT_TYPE
OBJECT_NAME
Y
OBJECT_NAME
OBJECT_COPY
Y
OBJECT_COPY
REPOSITORY_DIRECTORY
Y
REPOSITORY_DIRECTORY
FILENAME
Y
FILENAME
OBJECT_ID
Y
OBJECT_ID
OBJECT_REVISION
Y
OBJECT_REVISION
PARENT_CHANNEL_ID
Y
PARENT_CHANNEL_ID
ROOT_CHANNEL_ID
Y
ROOT_CHANNEL_ID

ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
LOG_FIELD
N
LOG_FIELD

ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
METRICS_DATE
Y
METRICS_DATE
METRICS_CODE
Y
METRICS_CODE
METRICS_DESCRIPTION
Y
METRICS_DESCRIPTION
METRICS_SUBJECT
Y
METRICS_SUBJECT
METRICS_TYPE
Y
METRICS_TYPE
METRICS_VALUE
Y
METRICS_VALUE

0.0
0.0
5000
50
50
N
Y
50000
Y
N
1000
100
romote_host
localhost
8085
cluster
Encrypted 2be98afc86aa7f2e48818bd79ddc0ff89
Y
N
-
2021/06/27 17:25:19.192
-
2021/06/27 17:25:19.192
H4sIAAAAAAAAAAMAAAAAAAAAAAA=
N
111.198.10.15-smartcity-mysql8
111.198.10.15
MYSQL Native smartwell 11336 root Encrypted 2be98afc86aa7f2e48818bd79ddc0ff89 `EXTRA_OPTION_MYSQL.characterEncoding` utf8 `EXTRA_OPTION_MYSQL.rewriteBatchedStatements` true `EXTRA_OPTION_MYSQL.useCompression` true `EXTRA_OPTION_MYSQL.useSSL` false `EXTRA_OPTION_MYSQL.useServerPrepStmts` false `FORCE_IDENTIFIERS_TO_LOWERCASE` N `FORCE_IDENTIFIERS_TO_UPPERCASE` N `IS_CLUSTERED` N `PORT_NUMBER` 11336 `PRESERVE_RESERVED_WORD_CASE` Y `QUOTE_ALL_FIELDS` N `STREAM_RESULTS` Y `SUPPORTS_BOOLEAN_DATA_TYPE` Y `SUPPORTS_TIMESTAMP_DATA_TYPE` Y `USE_POOLING` N
111.198.10.15-smartwell
111.198.10.15
MYSQL Native smartwell 11102 root Encrypted 2be98afc86aa7f2a7aa0aa7738cc2fc9b `EXTRA_OPTION_MYSQL.characterEncoding` utf8 `EXTRA_OPTION_MYSQL.rewriteBatchedStatements` true `EXTRA_OPTION_MYSQL.useCompression` true `EXTRA_OPTION_MYSQL.useSSL` false `EXTRA_OPTION_MYSQL.useServerPrepStmts` false `FORCE_IDENTIFIERS_TO_LOWERCASE` N `FORCE_IDENTIFIERS_TO_UPPERCASE` N `INITIAL_POOL_SIZE` 2 `IS_CLUSTERED` N `MAXIMUM_POOL_SIZE` 1 `PORT_NUMBER` 11102 `PRESERVE_RESERVED_WORD_CASE` Y `QUOTE_ALL_FIELDS` N `STREAM_RESULTS` Y `SUPPORTS_BOOLEAN_DATA_TYPE` Y `SUPPORTS_TIMESTAMP_DATA_TYPE` Y `USE_POOLING` Y
区域表
表输出
Y
- 区域表
  TableInput Y 1 none 111.198.10.15-smartwell SELECT ID , AREA_NAME , PID , SIMPLENAME , LNG , LAT , LEVEL , PIDS , NUM , TARGET_ID_SYNC , TARGET_PID_SYNC , IS_SYNC FROM smartwell.sys_area 0 N N N N String normal ID 32 -1 区域表 ID . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal AREA_NAME 100 -1 区域表 AREA_NAME . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal PID 32 -1 区域表 PID . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal SIMPLENAME 50 -1 区域表 SIMPLENAME . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal LNG 30 -1 区域表 LNG . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal LAT 30 -1 区域表 LAT . , none N Y 0 N N N zh_CN Asia/Shanghai N Integer normal LEVEL 9 0 区域表 LEVEL ####0;-####0 . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal PIDS 100 -1 区域表 PIDS . , none N Y 0 N N N zh_CN Asia/Shanghai N Integer normal NUM 9 0 区域表 NUM ####0;-####0 . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal TARGET_ID_SYNC 32 -1 区域表 TARGET_ID_SYNC . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal TARGET_PID_SYNC 32 -1 区域表 TARGET_PID_SYNC . , none N Y 0 N N N zh_CN Asia/Shanghai N String normal IS_SYNC 1 -1 区域表 IS_SYNC . , none N Y 0 N N N zh_CN Asia/Shanghai N 124 118 Y
- 表输出
  TableOutput Y 1 none 111.198.10.15-smartcity-mysql8 smartwell

  sys_area

  10000
  N
  N
  Y
  Y
  N
  N
  Y
  N
  Y
  N
  ID
  ID
  PID
  PID
  AREA_NAME
  AREA_NAME
  SIMPLE_NAME
  SIMPLENAME
  LNG
  LNG
  LAT
  LAT
  LEVEL
  LEVEL
  PIDS
  PIDS
  NUM
  NUM
  SYNC_ID
  TARGET_ID_SYNC
  SYNC_PID
  TARGET_PID_SYNC
  IS_SYNC
  IS_SYNC
  496
  160
  Y
N