i have regenerate DDL and sql setting db2 as target.

In the local.properties under build dir i have set:
portal.database=db2

In the etc dir i create a new file named db2.properties:
hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect
portal.datasource.driver=com.ibm.db2.jcc.DB2Driver
portal.datasource.url=jdbc:db2:lclabs
portal.datasource.username=user
portal.datasource.password=psw

now build all successful.

But:

the setup.ddl create is incorrect when use unique clause:

create table jbp_users (
jbp_uid INTEGER not null generated by default as identity,
jbp_root_pref_set_id INTEGER unique,
jbp_uname VARCHAR(255) unique,
jbp_givenname VARCHAR(255),
jbp_familyname VARCHAR(255),
jbp_password VARCHAR(255),
jbp_realemail VARCHAR(255),
jbp_fakeemail VARCHAR(255),
jbp_regdate TIMESTAMP,
jbp_viewrealemail SMALLINT,
jbp_enabled SMALLINT,
primary key (jbp_uid)
);

but this statement is not correct for db2: a unique attribute cannot be NULL

So i correct it using

create table jbp_users (
jbp_uid INTEGER not null generated by default as identity,
jbp_root_pref_set_id INTEGER not null unique,
jbp_uname VARCHAR(255) not null unique,
jbp_givenname VARCHAR(255),
jbp_familyname VARCHAR(255),
jbp_password VARCHAR(255),
jbp_realemail VARCHAR(255),
jbp_fakeemail VARCHAR(255),
jbp_regdate TIMESTAMP,
jbp_viewrealemail SMALLINT,
jbp_enabled SMALLINT,
primary key (jbp_uid)
);

this correction is done for all attribute table that use the unique clause.

Sql statements are not correct anyway:

This are the generated statements:

insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('1', 'admin', MD5('admin'), 'portal@example.com', NOW(), '1', '1');
insert into jbp_users (jbp_uid, jbp_uname, jbp_password, jbp_realemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) values ('2', 'user', MD5('user'), 'portal@example.com', NOW(), '1', '1');
insert into jbp_roles (jbp_rid, jbp_name, jbp_displayname) values ('1', 'Admins', 'Administrators');
insert into jbp_roles (jbp_rid, jbp_name, jbp_displayname) values ('2', 'Users', 'Users');
insert into jbp_role_membership (jbp_uid, jbp_rid) values ('1', '1');
insert into jbp_role_membership (jbp_uid, jbp_rid) values ('2', '2');

but:
MD5 and NOW function are not supported by DB2
NOW() must be replaced by CURRENT_TIMESTAMP,
MD5... is not supported.
Numeric values must don't have '
All unique attribute must be set, so for example jbp_root_pref_set_id is now not null and so the insert statement must set this column value, but for this field there is a contraint, so what is correct?
remove the constraint, remove the unique clause, or what?