When I execute the script messenger_db2.sql to create the jive database, the ddl defines a primary key greater than 1024 bytes - this is an error in DB2. Obviously, the subsequent CREATE INDEX statements fail as well, since the tables are not created.
I am using DB2 V8.1.2 on RH Linux. Jive Messenger V2.1.0 installed from jive_messenger_2_1_0.rpm.
Any workarounds or fixes for this?
This is an excerpt from the DB2 doc concerning PRIMARY KEY:
PRIMARY KEY (column-name,…)
Defines a primary key composed of the identified columns. The clause must not be specified more than once, and the identified columns must be defined as NOT NULL. Each column-name must identify a column of the table, and the same column must not be identified more than once.
The number of identified columns must not exceed 16, and the sum of their stored lengths must not exceed 1024 (refer to Byte Counts for the stored lengths).
These are the failing CREATEs:
CREATE TABLE mucAffiliation (
roomID INTEGER NOT NULL,
jid VARCHAR(1024) NOT NULL,
affiliation INTEGER NOT NULL,
CONSTRAINT mucAffiliation_pk PRIMARY KEY (roomID, jid)
);
CREATE TABLE mucMember (
roomID INTEGER NOT NULL,
jid VARCHAR(1024) NOT NULL,
nickname VARCHAR(255) NULL,
firstName VARCHAR(100) NULL,
lastName VARCHAR(100) NULL,
url VARCHAR(100) NULL,
email VARCHAR(100) NULL,
faqentry VARCHAR(100) NULL,
CONSTRAINT mucMember_pk PRIMARY KEY (roomID, jid)
);