DB2 Online schema update steps are not working [DBZ-6339]
- 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
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