Andres Gomez Casanova - 2014-05-30

I created a working patch for DB2. I published in GitHub: https://github.com/angoca/BenchmarkSQL/tree/my-version

The modified files /run/*_DB2

There is only one issue: DB2 does not support the following grammar

create table benchmarksql.history (
  hist_id  integer not null default nextval('hist_id_seq') primary key,

The DB2 porting does not perform completely equally. It could be:

  • GENERATED BY DEFAULT but the counter should be reseted after loading the values.
  • GENERATED ALWAYS generate errors and the business logic should be changed
  • GENERATED BY DEFAULT but without Primary key.

Best regards,