Skip to content

IBMDb2Settings

Source code in docs_src/capo_database_migration_service/types/ibm_db2_settings.py
class IBMDb2Settings(TypedDict, closed=True):
    database_name: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>Database name for the endpoint.</p>"""
    password: NotRequired[
        "capo_database_migration_service.types.secret_string.SecretString"
    ]
    """<p>Endpoint connection password.</p>"""
    port: NotRequired[
        "capo_database_migration_service.types.integer_optional.IntegerOptional"
    ]
    """<p>Endpoint TCP port. The default value is 50000.</p>"""
    server_name: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>Fully qualified domain name of the endpoint.</p>"""
    set_data_capture_changes: NotRequired[
        "capo_database_migration_service.types.boolean_optional.BooleanOptional"
    ]
    """<p>Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.</p>"""
    current_lsn: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.</p>"""
    max_k_bytes_per_read: NotRequired[
        "capo_database_migration_service.types.integer_optional.IntegerOptional"
    ]
    """<p>Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.</p>"""
    username: NotRequired["capo_database_migration_service.types.string.String"]
    """<p>Endpoint connection user name.</p>"""
    secrets_manager_access_role_arn: NotRequired[
        "capo_database_migration_service.types.string.String"
    ]
    """<p>The full Amazon Resource Name (ARN) of the IAM role that specifies DMS as the trusted entity and grants the required permissions to access the value in <code>SecretsManagerSecret</code>. The role must allow the <code>iam:PassRole</code> action. <code>SecretsManagerSecret</code> has the value of the Amazon Web Services Secrets Manager secret that allows access to the Db2 LUW endpoint. </p> <note> <p>You can specify one of two sets of values for these permissions. You can specify the values for this setting and <code>SecretsManagerSecretId</code>. Or you can specify clear-text values for <code>UserName</code>, <code>Password</code>, <code>ServerName</code>, and <code>Port</code>. You can't specify both. For more information on creating this <code>SecretsManagerSecret</code> and the <code>SecretsManagerAccessRoleArn</code> and <code>SecretsManagerSecretId</code> required to access it, see <a href="https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Security.html#security-iam-secretsmanager">Using secrets to access Database Migration Service resources</a> in the <i>Database Migration Service User Guide</i>.</p> </note>"""
    secrets_manager_secret_id: NotRequired[
        "capo_database_migration_service.types.string.String"
    ]
    """<p>The full ARN, partial ARN, or friendly name of the <code>SecretsManagerSecret</code> that contains the Db2 LUW endpoint connection details.</p>"""
    load_timeout: NotRequired[
        "capo_database_migration_service.types.integer_optional.IntegerOptional"
    ]
    """<p>The amount of time (in milliseconds) before DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).</p>"""
    write_buffer_size: NotRequired[
        "capo_database_migration_service.types.integer_optional.IntegerOptional"
    ]
    """<p>The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).</p>"""
    max_file_size: NotRequired[
        "capo_database_migration_service.types.integer_optional.IntegerOptional"
    ]
    """<p>Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.</p>"""
    keep_csv_files: NotRequired[
        "capo_database_migration_service.types.boolean_optional.BooleanOptional"
    ]
    """<p>If true, DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.</p> <p>The default value is false. </p>"""

current_lsn instance-attribute

current_lsn: NotRequired[String]

For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.

database_name instance-attribute

database_name: NotRequired[String]

Database name for the endpoint.

keep_csv_files instance-attribute

keep_csv_files: NotRequired[BooleanOptional]

If true, DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.

The default value is false.

load_timeout instance-attribute

load_timeout: NotRequired[IntegerOptional]

The amount of time (in milliseconds) before DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).

max_file_size instance-attribute

max_file_size: NotRequired[IntegerOptional]

Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.

max_k_bytes_per_read instance-attribute

max_k_bytes_per_read: NotRequired[IntegerOptional]

Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.

password instance-attribute

password: NotRequired[SecretString]

Endpoint connection password.

port instance-attribute

port: NotRequired[IntegerOptional]

Endpoint TCP port. The default value is 50000.

secrets_manager_access_role_arn instance-attribute

secrets_manager_access_role_arn: NotRequired[String]

The full Amazon Resource Name (ARN) of the IAM role that specifies DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the Amazon Web Services Secrets Manager secret that allows access to the Db2 LUW endpoint.

You can specify one of two sets of values for these permissions. You can specify the values for this setting and SecretsManagerSecretId. Or you can specify clear-text values for UserName, Password, ServerName, and Port. You can't specify both. For more information on creating this SecretsManagerSecret and the SecretsManagerAccessRoleArn and SecretsManagerSecretId required to access it, see Using secrets to access Database Migration Service resources in the Database Migration Service User Guide.

secrets_manager_secret_id instance-attribute

secrets_manager_secret_id: NotRequired[String]

The full ARN, partial ARN, or friendly name of the SecretsManagerSecret that contains the Db2 LUW endpoint connection details.

server_name instance-attribute

server_name: NotRequired[String]

Fully qualified domain name of the endpoint.

set_data_capture_changes instance-attribute

set_data_capture_changes: NotRequired[BooleanOptional]

Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.

username instance-attribute

username: NotRequired[String]

Endpoint connection user name.

write_buffer_size instance-attribute

write_buffer_size: NotRequired[IntegerOptional]

The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).