aws dms describe-replication-tasks

From wikieduonline
Revision as of 08:08, 7 September 2021 by Welcome (talk | contribs)
Jump to navigation Jump to search

  • aws dms describe-replication-tasks
aws dms describe-replication-tasks --output text
REPLICATIONTASKS        YOUR_REPLICATION_NAME       arn:aws:dms:eu-central-1:789058898387:rep:M5K2FJYNM5KSDSX7O5D7QBCWZPD3G5JLLU5PY6I       arn:aws:dms:eu-central- 1:789058898387:task:FSQLJUN3IFPHJSLMGMRD62I3TERMZZ5Y3KRIM2I      2021-01-08T15:18:51.832000+04:00        production-postgres-redshift-replication-task   {"Logging":{"EnableLogging":false,"LogComponents":[{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"DATA_STRUCTURE"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"COMMUNICATION"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"IO"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"COMMON"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"FILE_FACTORY"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"FILE_TRANSFER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"REST_SERVER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"ADDONS"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"TARGET_LOAD"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"TARGET_APPLY"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"SOURCE_UNLOAD"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"SOURCE_CAPTURE"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"TRANSFORMATION"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"SORTER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"TASK_MANAGER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"TABLES_MANAGER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"METADATA_MANAGER"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"PERFORMANCE"},{"Severity":"LOGGER_SEVERITY_DEFAULT","Id":"VALIDATOR_EXT"}],"CloudWatchLogGroup":null,"CloudWatchLogStream":null},"ControlTablesSettings":{"historyTimeslotInMinutes":5,"HistoryTimeslotInMinutes":5,"StatusTableEnabled":false,"SuspendedTablesTableEnabled":false,"HistoryTableEnabled":false,"ControlSchema":""},"StreamBufferSettings":{"StreamBufferCount":3,"CtrlStreamBufferSizeInMB":5,"StreamBufferSizeInMB":8},"ErrorBehavior":{"FailOnNoTablesCaptured":true,"ApplyErrorUpdatePolicy":"LOG_ERROR","FailOnTransactionConsistencyBreached":false,"RecoverableErrorThrottlingMax":1800,"DataErrorEscalationPolicy":"SUSPEND_TABLE","ApplyErrorEscalationCount":0,"RecoverableErrorStopRetryAfterThrottlingMax":false,"RecoverableErrorThrottling":true,"ApplyErrorFailOnTruncationDdl":false,"DataTruncationErrorPolicy":"LOG_ERROR","ApplyErrorInsertPolicy":"LOG_ERROR","ApplyErrorEscalationPolicy":"LOG_ERROR","RecoverableErrorCount":-1,"DataErrorEscalationCount":0,"TableErrorEscalationPolicy":"STOP_TASK","RecoverableErrorInterval":5,"ApplyErrorDeletePolicy":"IGNORE_RECORD","TableErrorEscalationCount":0,"FullLoadIgnoreConflicts":true,"DataErrorPolicy":"LOG_ERROR","TableErrorPolicy":"SUSPEND_TABLE"},"LoopbackPreventionSettings":null,"CharacterSetSettings":null,"ChangeProcessingTuning":{"StatementCacheSize":50,"CommitTimeout":1,"BatchApplyPreserveTransaction":true,"BatchApplyTimeoutMin":1,"BatchSplitSize":0,"BatchApplyTimeoutMax":30,"MinTransactionSize":1000,"MemoryKeepTime":60,"BatchApplyMemoryLimit":500,"MemoryLimitTotal":1024},"FullLoadSettings":{"CommitRate":10000,"StopTaskCachedChangesApplied":false,"StopTaskCachedChangesNotApplied":false,"MaxFullLoadSubTasks":8,"TransactionConsistencyTimeout":600,"CreatePkAfterFullLoad":false,"TargetTablePrepMode":"DROP_AND_CREATE"},"ChangeProcessingDdlHandlingPolicy":{"HandleSourceTableDropped":true,"HandleSourceTableTruncated":true,"HandleSourceTableAltered":true},"TargetMetadata":{"ParallelApplyBufferSize":0,"ParallelApplyQueuesPerThread":0,"ParallelApplyThreads":0,"TargetSchema":"","InlineLobMaxSize":0,"ParallelLoadQueuesPerThread":0,"SupportLobs":true,"LobChunkSize":64,"TaskRecoveryTableEnabled":false,"ParallelLoadThreads":0,"LobMaxSize":32,"BatchApplyEnabled":true,"FullLobMode":false,"LimitedSizeLobMode":true,"LoadMaxFileSize":0,"ParallelLoadBufferSize":0},"PostProcessingRules":null,"BeforeImageSettings":null}    2021-03-25T23:04:19.346000+04:00        arn:aws:dms:eu-central-1:789058898387:endpoint:OYLT23SR6PPAVOR7IHCQ2E7VVI7K4QWL2XBHIDQ  running {"rules": [{"rule-type": "selection", "rule-id": "1", "rule-name": "1", "object-locator": {"schema-name": "%", "table-name": "%"}, "rule-action": "include"}, {"rule-type": "selection", "rule-id": "2", "rule-name": "2", "object-locator": {"schema-name": "oauth", "table-name": "%"}, "rule-action": "exclude"}, {"rule-type": "transformation", "rule-id": "3", "rule-name": "3", "rule-action": "add-prefix", "rule-target": "schema", "object-locator": {"schema-name": "%"}, "value": "YourVALUE"}]}     arn:aws:dms:eu-central-1:789058898387:endpoint:TZLMICYROLT6RY62NKLGF3SKS6QQ2N2FY7FYP5A
REPLICATIONTASKSTATS    11398059722     2021-03-25T23:04:28.467000+04:00        2021-08-04T21:12:08.748000+04:00        100     2021-03-25T23:04:29.025000+04:00        2021-03-27T14:45:39.232000+04:00        2021-03-27T14:45:38.240000+04:00        3       62      0       0

See also

Advertising: