AWS dms documentation change
Summary
Updated documentation for Db2 LUW source endpoint settings: corrected parameter casing (CurrentLsn→CurrentLSN), moved ConnectionTimeout/executeTimeout/StartFromContext from ECAs to endpoint settings table, added JSON syntax examples, and removed redundant ECA section
Security assessment
Changes primarily focus on documentation structure and parameter casing corrections. While timeout settings (ConnectionTimeout/executeTimeout) could relate to availability, there's no evidence these changes address specific vulnerabilities. No security advisories or vulnerability references are mentioned.
Diff
diff --git a/dms/latest/userguide/CHAP_Source.DB2.md b/dms/latest/userguide/CHAP_Source.DB2.md index 7dc36c9bc..197ed1d72 100644 --- a//dms/latest/userguide/CHAP_Source.DB2.md +++ b//dms/latest/userguide/CHAP_Source.DB2.md @@ -5 +5 @@ -Prerequisites when using Db2 LUW as a sourceLimitations when using Db2 LUW as a sourceEndpoint settingsEndpoint ECAsSource data types for Db2 LUW +Prerequisites when using Db2 LUW as a sourceLimitations when using Db2 LUW as a sourceEndpoint settingsSource data types for Db2 LUW @@ -39 +39 @@ For full-load only tasks, the DMS user account needs DATAACCESS permission. - * When using IBM DB2 for LUW version 9.7 as a source, set the extra connection attribute (ECA), `CurrentLsn` as follows: + * When using IBM DB2 for LUW version 9.7 as a source, set the extra connection attribute (ECA), `CurrentLSN` as follows: @@ -41 +41 @@ For full-load only tasks, the DMS user account needs DATAACCESS permission. -`CurrentLsn=`LSN`` where ``LSN`` specifies a log sequence number (LSN) where you want the replication to start. Or, `CurrentLsn=`scan``. +`CurrentLSN=`LSN`` where ``LSN`` specifies a log sequence number (LSN) where you want the replication to start. Or, `CurrentLSN=`scan``. @@ -108 +108 @@ When using ongoing replication (CDC), the following limitations apply: - * When migrating from a DPF environment, we recommend first running a Full Load task without cached events, and then running CDC-only tasks. We recommend running one task per Db2 node, starting from the Full Load start timestamp or LRI (log record identifier) you set using the `StartFromContext` endpoint extra connection attribute. For information about determining your replication start point, see [ Finding the LSN or LRI value for replication start ](https://www.ibm.com/support/pages/db2-finding-lsn-or-lri-value-replication-start) in the _IBM Support documentation_. + * When migrating from a DPF environment, we recommend first running a Full Load task without cached events, and then running CDC-only tasks. We recommend running one task per Db2 node, starting from the Full Load start timestamp or LRI (log record identifier) you set using the `StartFromContext` endpoint setting. For information about determining your replication start point, see [ Finding the LSN or LRI value for replication start ](https://www.ibm.com/support/pages/db2-finding-lsn-or-lri-value-replication-start) in the _IBM Support documentation_. @@ -110 +110 @@ When using ongoing replication (CDC), the following limitations apply: - * For ongoing replication (CDC), if you plan to start replication from a specific timestamp, you must set the `StartFromContext` extra connection attribute to the required timestamp. + * For ongoing replication (CDC), if you plan to start replication from a specific timestamp, you must set the `StartFromContext` connection attribute to the required timestamp. @@ -123,5 +123 @@ When using ongoing replication (CDC), the following limitations apply: -You can specify the settings when you create the source endpoint using the AWS DMS console, or by using the `create-endpoint` command in the [AWS CLI](https://docs.aws.amazon.com/cli/latest/reference/dms/create-endpoint.html), with the - -`--ibm-db2-settings `'{"EndpointSetting1": "value1","EndpointSetting2": "value2"}'`` - -JSON syntax. +You can use endpoint settings to configure your Db2 LUW source database similar to using extra connection attributes. You specify the settings when you create the source endpoint using the AWS DMS console, or by using the `create-endpoint` command in the [AWS CLI](https://docs.aws.amazon.com/cli/latest/reference/dms/index.html), with the `--ibm-db2-settings '{"`EndpointSetting"`: `"value"`, `...`}'` JSON syntax. @@ -131 +127 @@ The following table shows the endpoint settings that you can use with Db2 LUW as -Setting Name | Description +Name | Description @@ -133 +129,2 @@ Setting Name | Description -`CurrentLsn` | For ongoing replication (CDC), use `CurrentLsn` to specify a log sequence number (LSN) where you want the replication to start. +`CurrentLSN` | For ongoing replication (CDC), use `CurrentLSN` to specify a log sequence number (LSN) where you want the replication to start. +`ConnectionTimeout` | Use this extra connection attribute (ECA) to set the endpoint connection timeout for the Db2 LUW endpoint, in seconds. The default value is 10 seconds. ECA Example: `ConnectionTimeout=30`. @@ -135,0 +133 @@ Setting Name | Description +`StartFromContext` | For ongoing replication (CDC), use `StartFromContext` to specify a log's lower limit from where to start the replication. `StartFromContext` accepts different forms of values. Valid values include: @@ -137 +135 @@ Setting Name | Description -## Extra Connection Attributes (ECAs) when using Db2 LUW as a source for AWS DMS + * `timestamp` (UTC). For example: @@ -139 +137 @@ Setting Name | Description -You can specify the Extra Connection Attributes (ECAs) when you create the source endpoint using the AWS DMS console, or by using the `create-endpoint` command in the [AWS CLI](https://docs.aws.amazon.com/cli/latest/reference/dms/create-endpoint.html), with the + '{"StartFromContext": "timestamp:2021-09-21T13:00:00"}' @@ -141 +138,0 @@ You can specify the Extra Connection Attributes (ECAs) when you create the sourc -`--extra-connection-attributes `'ECAname1=value1;ECAname2=value2;'`` @@ -143 +139,0 @@ You can specify the Extra Connection Attributes (ECAs) when you create the sourc -The following table shows the ECAs that you can use with Db2 LUW as a source. @@ -145,5 +140,0 @@ The following table shows the ECAs that you can use with Db2 LUW as a source. -Attribute Name | Description ----|--- -`ConnectionTimeout` | Use this ECA to set the endpoint connection timeout for the Db2 LUW endpoint, in seconds. The default value is 10 seconds. Example: `ConnectionTimeout=30;` -`executeTimeout` | Extra connection attribute which sets the statement (query) timeout for the DB2 LUW endpoint, in seconds. The default value is 60 seconds. Example: `executeTimeout=120;` -`StartFromContext` | For ongoing replication (CDC), use `StartFromContext` to specify a log's lower limit from where to start the replication. `StartFromContext` accepts different forms of values. Valid values include: @@ -151 +142,3 @@ Attribute Name | Description - * `timestamp` (UTC). Example: `StartFromContext=timestamp:2026-02-23T13:00:00;` + * `NOW` For IBM DB2 LUW version 10.5 and higher, NOW combined with CurrentLSN: scan, starts the task from the latest LSO. For example: + + '{"CurrentLSN": "scan", "StartFromContext": "NOW"}' @@ -155 +147,0 @@ Attribute Name | Description - * `NOW` For IBM DB2 LUW version 10.5 and higher, NOW combined with `'{"CurrentLsn": "scan"}'` endpoint setting, starts the task from the latest Log Sequence Offset (LSO). Example: `StartFromContext=NOW;` @@ -156,0 +149 @@ Attribute Name | Description + * A specific LRI. For example: @@ -157,0 +151 @@ Attribute Name | Description + '{"StartFromContext": "0100000000000022CC000000000004FB13"}' @@ -159 +152,0 @@ Attribute Name | Description - * A specific Log Record Identifier (LRI). Example: `StartFromContext=0100000000000022CC000000000004FB13;` @@ -176,0 +170,2 @@ In that output, the log file is S0000002.LOG and the **StartFromContext** LRI va +`executeTimeout` | Extra connection attribute which sets the statement (query) timeout for the DB2 LUW endpoint, in seconds. The default value is 60 seconds. ECA Example: `executeTimeout=120;` +