debezium / debezium/dbz

DB2 Online schema update steps are not working [DBZ-6339]

Open
#797 0 comments 0 reactions 0 assignees View on GitHub
component/documentation migrated-from-jira type/bug
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-6339](https://issues.redhat.com/browse/DBZ-6339)

The provided steps in the *DB2 Online schema update steps* are not in the proper order. Step 4 and 5 shall be moved after Step 1. 

[https://debezium.io/documentation/reference/2.2/connectors/db2.html#db2-hot-schema-update]

Procedure when adding a column to the end of a table
# Lock the source tables whose schema you want to change.
# In the ASN register table, mark the locked tables as {{{}INACTIVE{}}}.
# [Reinitialize the ASN capture service.|https://debezium.io/documentation/reference/1.9/connectors/db2.html#debezium-db2-reinitialize-asn-service]
# Apply all changes to the schemas for the source tables.
# Apply all changes to the schemas for the corresponding change-data tables.
# In the ASN register table, mark the source tables as {{{}ACTIVE{}}}.
# [Reinitialize the ASN capture service.|https://debezium.io/documentation/reference/1.9/connectors/db2.html#debezium-db2-reinitialize-asn-service]
# Optional. Restart the connector to see updated column names in change events.

*The expected order is the following:*
# Lock the source tables whose schema you want to change.
# Apply all changes to the schemas for the source tables.
# Apply all changes to the schemas for the corresponding change-data tables.
# In the ASN register table, mark the locked tables as {{{}INACTIVE{}}}.
# [Reinitialize the ASN capture service.|https://debezium.io/documentation/reference/1.9/connectors/db2.html#debezium-db2-reinitialize-asn-service]
# In the ASN register table, mark the source tables as {{{}ACTIVE{}}}.
# [Reinitialize the ASN capture service.|https://debezium.io/documentation/reference/1.9/connectors/db2.html#debezium-db2-reinitialize-asn-service]
# Optional. Restart the connector to see updated column names in change events.

The integration test are also using these steps instead of what is written in the current documentation. 
[https://github.com/debezium/debezium-connector-db2/blob/5ac3895b6ed42fff4e850ef7eb39448047ed986f/src/test/java/io/debezium/connector/db2/Db2OnlineDefaultValueIT.java]

The Other documentation sections *_Procedure when adding a column to the middle of a table_*  and *_Offline schema update_* are likely have the same / similar issues.

Contributor guide

Open the contributing guide

Research direction

Start with the DB2 hot schema update section at the linked documentation URL and compare its procedures with src/test/java/io/debezium/connector/db2/Db2OnlineDefaultValueIT.java. Check the column-at-end, column-in-the-middle, and offline schema update sections for the same ordering issue. Done means the documented steps match the integration test steps.

Written by the indexing model from the issue text.

Assessment

Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
Half a day
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.