IBM DB2 LUW

Verification Category: 

Advanced

Platform Provider: 

Other / On-premise

Versions Verified: 

11.5.7+

Maintainer: 

Liquibase

Documentation

Detailed verification results:

Pass
Partial
Fail
N/A

Foundational Capabilities:

Change Management Commands
update family test
rollback family test
“SQL” generating variant
validate
drop-all
mark-next-changeset-ran
changelog-sync
Change Tracking Commands
history
status
tag
unexpected-changesets
Native Language ChangeTypes
< sql > (or custom equivalent)
< sqlFile > (or custom equivalent)
< include >
< includeAll >

Advanced Capabilities:

Database Inspection Commands
generate-changelog
SQL
XML
JSON
YAML
snapshot family
diff (between databases)
diff (against snapshot)
diff-changelog (between databases)
SQL
XML
JSON
YAML
diff-changelog (against snapshot)
SQL
XML
JSON
YAML
Native Executor
unavailable
Supported Standard ChangeTypes
Table
createTable
dropTable
setTableRemarks
renameTable
Column
addColumn
dropColumn
renameColumn
modifyDataType
setColumnRemarks
addAutoIncrement
Index
createIndex
dropIndex
View
createView
dropView
renameView
Procedure
createProcedure
dropProcedure
Sequence
createSequence
dropSequence
renameSequence
alterSequence
Function
createFunction
dropFunction

Detailed verification results:

Pass
Partial
Fail
N/A

Foundational Capabilities:

Change Management Commands

🟢  update family test

🟢  rollback family test

🟢  “SQL” generating variants

🟢  validate

🟢  drop-all

🟢  mark-next-changeset-ran

🟢  changelog-sync

Change Tracking Commands

🟢  history

🟢  status

🟢  tag

🟢  unexpected-changesets

Native Language ChangeTypes

🟢  < sql > (or custom equivalent)

🟢  < sqlFile > (or custom equivalent)

🟢  < include >

🟢  < includeAll >

Advanced Capabilities:

Database Inspection Commands

⚪  generate-changelog

    🟢  SQL

    🟢  XML

    🟢  JSON

    🟢  YAML

⚪  snapshot family

⚪  diff (between databases)

⚪  diff (against snapshot)

⚪  diff-changelog (between databases)

    🟢  SQL

    🟢  XML

    🟢  JSON

    🟢  YAML

⚪  diff-changelog (against snapshot)

    🟢  SQL

   🟢  XML

    🟢  JSON

    🟢  YAML

Native Executor

🔴  unavailable

Supported Standard ChangeTypes

Table

   🟢  createTable

   🟢  dropTable

   🟢  setTableRemarks

   🟢  renameTable

Column

    🟢  addColumn

    🟢  dropColumn

    🟢  renameColumn

    🟢  modifyDataType

    🟢  setColumnRemarks

    🟢  addAutoIncrement

Index

    🟢  createIndex

    🟢  dropIndex

View

    🟢  createView

    🟢  dropView

    🔴  renameView

Procedure

    🟢  createProcedure

    🟢  dropProcedure

Sequence

    🟢  createSequence

    🟢  dropSequence

    🔴  renameSequence

    🟢  alterSequence

Function

    🟢  createFunction

    🟢  dropFunction

Package

    🟢  createPackage

    🟢  createPackageBody

    🟢  dropPackage

    🟢  dropPackageBody

Synonym

    🔴  createSynonym

    🔴  dropSynonym

Trigger

    🟢  createTrigger

    🔴  enableTrigger

    🟢  dropTrigger

    🔴  disableTrigger

    🟢  renameTrigger

Check

    🔴  addCheckConstraint

    🔴  enableCheckConstraint

    🔴  dropCheckConstraint

    🔴  disableCheckConstraint

Default value

    🟢  addDefaultValue

    🟢  dropDefaultValue

Foreign key

    🟢  addForeignKeyConstraint

    🟢  dropForeignKeyConstraint

    🟢  dropAllForeignKeyConstraints\

Not null

    🟠  addNotNullConstraint

    🟠  dropNotNullConstraint

Primary key

    🟢  addPrimaryKey

    🟢  dropPrimaryKey

Unique key

    🟢  addUniqueConstraint

    🟢  dropUniqueConstraint

Data

    🟢  addLookupTable

    🟢  delete

    🟢  insert

    🟢  loadData

    🟢  loadUpdateData

    🟢  mergeColumns

    🟢  update

Miscellaneous

    🟢  customChange

    🟢  empty

    🟢  executeCommand

    🔴  markUnused

    🟢  output

    🟢  stop

    🟢  tagDatabase

Custom ChangeTypes

How to Get Started?

Interested in trying the more advanced features of Liquibase Pro? Sign up for a free 30-day trial.

Try Liquibase Pro Now