Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support dashDB #1529

Closed
ibm-garage-nice opened this issue Feb 13, 2017 · 1 comment
Closed

Support dashDB #1529

ibm-garage-nice opened this issue Feb 13, 2017 · 1 comment
Labels
d: DB2 r: duplicate t: feature

Comments

@ibm-garage-nice
Copy link

What version of Flyway are you using?

4.1.0

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)

All

What database are you using (type & version)?

dashDB (based on db2 10.5 running on Bluemix - the IBM cloud platform)

What operating system are you using?

MacOS

What did you do?

Do a migrate

What did you expect to see?

metadata table created

What did you see instead?

A dirty "DB2 SQL Error: SQLCODE=-1666, SQLSTATE=42613, SQLERRMC=CHECK, DRIVER=4.16.53"

How could you fix that?

Quickly: just add the "ORGANIZE BY ROW" directive in the createMetadataTable.sql script for db2:
CREATE TABLE ... ( ...) ORGANIZE BY ROW;

The row organization is the default mode for db2 but not for dashDB (column organization).
@axelfontaine
Copy link
Contributor

Duplicate of #1732

@axelfontaine axelfontaine marked this as a duplicate of #1732 Nov 17, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
d: DB2 r: duplicate t: feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@axelfontaine @ibm-garage-nice