Unexpected CREATE SEQUENCE defaults in DB2390V8Dialect

Description

While I have only worked with DB2 on other platforms and thus not with DB2/390 v8, when I look at the DB2390V8Dialect#getCreateSequenceString(String) implementation (see https://github.com/hibernate/hibernate-orm/blame/master/hibernate-core/src/main/java/org/hibernate/dialect/DB2390V8Dialect.java#L26-L28) it strikes me as odd to have the NOCACHE option in there. Typically the default would be CACHE 20 (which is what happens when the CACHE clause is left out). Also a few of the other clauses could probably be left out, since they correspond to the default value and this is also how Hibernate works in the case of most other supported dialects.

NOCACHE is of course also bad for performance and I think it would for this reason also make sense to just leave out the CACHE clause here.

Environment

None

Assignee

Unassigned

Reporter

Knut Wannheden

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure