What support does Liquibase have for DB2 for zOS Platforms?

Features

The Liquibase DB2 for zOS Secure enhancement includes all the Liquibase features that are supported by Liquibase DB2 for zOS Open Source. In addition, Liquibase DB2 for zOS Secure lets you use Liquibase Secure features including:

• Policy Checks: automatically analyze your changelogs for desired format and behavior to increase deployment success rates and uphold security best practices

• Secrets Management: keep your authentication data secure by integrating with third-party secrets vaults

• Structured Logging: improve your database observability by easily reading Liquibase data in your favorite analytics tool

• Operation Reports: generate reports of operations you perform on your database

• Flow Files: create repeatable, portable, and platform-independent Liquibase workflows to run in any of your CI/CD tools

• Remote file access: centralize file management with AWS S3 to build a reusable repository of Liquibase files you can update and retrieve

• Targeted rollback: avoid collateral damage by specifying which changesets in your changelog to undo

• Stored Logic: capture stored logic objects like procedures, functions, packages, and triggers

Supported Change types

• addCheckConstraint

• addColumn

• addDefaultValue

• addForeignKeyConstraint

• addLookupTable

• addPrimaryKey

• addUniqueConstraint

• alterSequence

• createFunction

• createIndex

• createPackage

• createPackageBody

• createProcedure

• createSequence

• createSynonym

• createTable

• createTrigger

• createView

• delete

• dropAllForeignKeyConstraints

• dropCheckConstraint

• dropColumn

• dropDefaultValue

• dropForeignKeyConstraint

• dropFunction

• dropIndex

• dropPrimaryKey

• dropProcedure

• dropSequence

• dropSynonym

• dropTable

• dropTrigger

• dropUniqueConstraint

• dropView

• executeCommand

• insert

• loadData

• loadUpdateData

• renameColumn

• renameTable

• setColumnRemarks

• setTableRemarks

• sql

• sqlFile