[JS2-1207] Problem with DB2 create and seed

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.2.1, 2.2.2
• Component/s: Deployment
• Environment: Windows 7, DB2 9.7
• Assignee: Unassigned
• Reporter: Frank Stalherm
• Created: 23/Aug/10 08:14
• Updated: 02/Sep/10 12:16

Description

I noticed two problems with the DB2 create and seed jobs.

If I use the db2 database name the tables MEDIATYPE_TO_MIMETYPE and MEDIATYPE_TO_CAPABILITY are shortened to MEDIATYPE_MIMETYPE and MEDIATYPE_CAPABILITY in the create script, which is fine. But if I try to seed them the long table names are used.

This is no issue if I use db2v8 as the database name.
Problem here is that two index names are reused in the script, resulting in SQLSTATE 42710 on second execution:

CREATE INDEX IX_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
CREATE UNIQUE INDEX UN_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID, NAME, LOCALE, VALUE);

As a result the maven create targets are not working.

If I change this problem manually in the SQL script an initialize my database manually, the seeding works fine.

On DB2 a page size of min. 8k is required. Is there is documentation or howto? Default on Db2 is 4k.
This was not the case with JS 2.1.x . I thought I should mention this.