Flyway Db2 zOS SQL ID Setting
Published 15 January 2025
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>