Omni-Gen Installation Prerequisites for Db2

If you are using Db2 with Omni-Gen, then the following must be executed against your Db2 instance to ensure that the required storage is allocated for the RAMP tables.

CREATE BUFFERPOOL BP32K SIZE 2000 PAGESIZE 32K;

CREATE LARGE TABLESPACE "RAMPSPACE" 
    IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP" 
    PAGESIZE 32 K
    MANAGED BY AUTOMATIC STORAGE
    AUTORESIZE YES
    EXTENTSIZE 32
    BUFFERPOOL "BP32K" 
    OVERHEAD INHERIT
    TRANSFERRATE INHERIT
    DATA TAG INHERIT
    USING STOGROUP "IBMSTOGROUP" 
    NO FILE SYSTEM CACHING;

GRANT USE OF TABLESPACE "RAMPSPACE" TO  PUBLIC;