Redgate Flyway

For PostgreSQL users - where are your DBs hosted?

Flyway Db2 zOS SQL ID Setting

Description

The SQLID to be used in execution. This is the user under which it will create objects like tables etc. As creator, this user will get all rights on the object. If not explicitly set, the DB2z community support plugin will use the schema name as SQLID.

Type

String

Default

none

Usage

Flyway Desktop

This can't be configured via Flyway Desktop, although it will be honoured.

Command-line

./flyway -db2z.sqlId="example_group" info

TOML Configuration File

[flyway.db2z]
sqlId="example_group"

Configuration File

flyway.db2z.sqlId="example_group"

Environment Variable

FLYWAY_DB2Z_SQL_ID=example_group

API

DB2ZConfigurationExtension dB2ZConfigurationExtension = configuration.getPluginRegister().getPlugin(DB2ZConfigurationExtension.class);
dB2ZConfigurationExtension.setSqlId("example_group");

Gradle

flyway {
    pluginConfiguration = [
        db2zSqlId: 'example_group'
    ]
}

Maven

<configuration>
    <pluginConfiguration>
        <db2zSqlId>example_group</db2zSqlId>
    </pluginConfiguration>
</configuration>

Didn't find what you were looking for?