The following example shows the SQL that can be generated to create required database objects; this SQL is proposed and it can be modified:
You can edit the SQL. For example:
CREATE NODEGROUP RDBING1 ON NODE (0); CREATE NODEGROUP RDBING2 ON NODE (0); CREATE REGULAR TABLESPACE RDBITSSC IN NODEGROUP RDBING1 MANAGED BY SYSTEM USING('RDBITSSC'); CREATE TABLE RDBI.AUTHID_TABLE ( PRIMARY_ID CHAR(8) NOT NULL, SECONDARY_ID CHAR(8) NOT NULL ) IN RDBITSSC PARTITIONING KEY (SECONDARY_ID) USING HASHING ; COMMENT ON TABLE RDBI.AUTHID_TABLE IS 'Secondary authorization ID table FOR RDBI';