Difference between revisions of "Aws dms describe-replication-tasks"
Jump to navigation
Jump to search
(Created page with "{{lowercase}} *<code>aws dms describe-replication-tasks</code> ==See also== * {{aws dms}} * {{RDS}} Category:AWS") |
|||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{lowercase}} | {{lowercase}} | ||
− | *<code>aws dms describe-replication-tasks</code> | + | *<code>[[aws dms]] describe-replication-tasks</code> |
+ | |||
+ | 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 | ||
+ | |||
+ | == Related terms == | ||
+ | * <code>[[aws dms create-replication-task]]</code> | ||
+ | * "MigrationType": "[[full-load-and-cdc]]", | ||
+ | * [[CloudWatch]]: <code>CloudWatchLogGroup":null,"CloudWatchLogStream":null</code> | ||
+ | * <code>[[aws list all]]</code> | ||
+ | * <code>[[aws dms describe-replication-instances]]</code> | ||
==See also== | ==See also== | ||
* {{aws dms}} | * {{aws dms}} | ||
− | * {{ | + | * {{AWS DMS}} |
[[Category:AWS]] | [[Category:AWS]] |
Latest revision as of 00:02, 22 May 2022
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
Related terms[edit]
aws dms create-replication-task
- "MigrationType": "full-load-and-cdc",
- CloudWatch:
CloudWatchLogGroup":null,"CloudWatchLogStream":null
aws list all
aws dms describe-replication-instances
See also[edit]
- AWS DMS,
AWS::DMS
,aws dms
[describe-events
|describe-replication-tasks
|describe-connections
|describe-account-attributes
|describe-replication-instances
|describe-table-statistics
|describe-replication-instance-task-logs
|describe-replication-task-assessment-results
|reload-tables
|create-event-subscription
|modify-replication-task
|describe-event-subscriptions ]
- AWS DMS, AWS DMS Studio,
AWS::DMS
,aws dms
, AWS DMS monitoring,AWS::DMS::EventSubscription
Advertising: