Deleting a bad changelog in Liquibase

Identify the change set you need to remove (to run again)

<changeSet author=“me” id=“2.1.0-x-table”>
<sqlFile path=“/mycustomsql.sql”
relativeToChangelogFile=“false” stripComments=“true” />
</changeSet>

2 – As your db instance owner, remove the change log entry

[db2inst1@db myfolder]$ db2 “DELETE from myschema.DATABASECHANGELOG WHERE ID = ‘2.1.0-x-table'”
DB20000I The SQL command completed successfully.

3 – Confirm the change log is removed

[db2inst1@db myfolder]$ db2 “select * from myschema.DATABASECHANGELOG WHERE ID = ‘2.1.0-x-table’”

Dump Change Log Checksum in Liquibase

I lost my changelog tables and the lock table for Liquibase

I was able to Dump Change Log in Liquibase, and then load the resulting inserts into the changelog.