Repository navigation
Migration to 6 database schema changes for IBM DB2 LUW #5450
natixis-caen
started this conversation in
Migration Support
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
In the migration guide section database-schema-changes it is written that IBM DB2 LUW (10.1+) does not support sequence renaming. It is indeed true but an alternative way is to create an alias for the already existing sequence.
Here is the IBM DB2 LUW documentation.
Here is the sql script:
CREATE ALIAS BATCH_JOB_INSTANCE_SEQ FOR SEQUENCE BATCH_JOB_SEQ;This solution has been tested and works as expected.
Regards
All reactions