[opencms-dev] OpenCms6.0 and DB2 (adapt database schema)

[Thomas Matal]

Hi list,
we are planning to run OpenCms 6.0 Beta 3 on DB2 and found the following
issues:
1) the database schema is not compliant with DB2 (e.g. long and long raw do
not exist and for some older DB2 versions there is a limitation of object
names length).
2) the createTables.sql does not work for all platforms, but this should be
a minor issue
3) for the database connection there are some recent posts in the mailing
archive, so I am waiting for answers

To solve issue 1) I am planning to modify the  database schema and adapt
the database access classes  - would you give me some information on where
to start ?
Which classes in which packages have to be modified? For example to me it
seems, that some SQL statements can be configured in query.properties. Is
this the single point, where SQL statements are set up?
Thanks you!

Thomas