Harriet_Kim_1764

How to add more CPs to the MQCP table for Oracle db in version 11.2?

Discussion created by Harriet_Kim_1764 on May 12, 2016

This statement is available in the Automation Engine full installation image.

Navigate to 

...\11.2\Automation.Engine_Image_11_2_16-05-02-1\db\oracle\11.2\uc_ddl.sql

In the uc_ddl.sql file, you will see that you will need to create a MQ1CP006 table and a MQ2CP006 table. 

You will be creating CP006 because by default, the database already has CPs 1-5. So if you will need more than this, then you will just have to increment to the next number.

CREATE TABLE MQ1CP006 ( MQCP_PK NUMBER(38,0) NOT NULL, MQCP_System VARCHAR2 (8 CHAR) NULL, MQCP_CAddr VARCHAR2 (32 CHAR) NULL, MQCP_CSRName VARCHAR2 (8 CHAR) NULL, MQCP_CAcv NUMBER(38,0) NULL, MQCP_BAddr VARCHAR2 (32 CHAR) NULL, MQCP_BSRName VARCHAR2 (8 CHAR) NULL, MQCP_BAcv NUMBER(38,0) NULL, MQCP_FAddr VARCHAR2 (32 CHAR) NULL, MQCP_LogAddr VARCHAR2 (32 CHAR) NULL, MQCP_PhysAddr VARCHAR2 (32 CHAR) NULL, MQCP_BTable VARCHAR2 (8 CHAR) NULL, MQCP_SchedTime DATE NULL, MQCP_Status NUMBER(38,0) NULL, MQCP_Priority NUMBER(38,0) NULL, MQCP_DRole VARCHAR2 (32 CHAR) NULL, MQCP_LAddr VARCHAR2 (32 CHAR) NULL, MQCP_Len NUMBER(38,0) NULL, MQCP_Msg BLOB NULL, CONSTRAINT PK_MQ1CP006 PRIMARY KEY ( MQCP_PK ) USING INDEX TABLESPACE UC4_INDEX ) LOB (MQCP_Msg) STORE AS (ENABLE STORAGE IN ROW CACHE) TABLESPACE UC4_DATA ENABLE ROW MOVEMENT NOCOMPRESS; CREATE SEQUENCE SQ_MQ1CP006 INCREMENT BY 1 START WITH 1 MAXVALUE 2147483647 MINVALUE 1 CYCLE CACHE 1000 NOORDER; CREATE INDEX NK_MQ1CP006_BAcv ON MQ1CP006 (MQCP_BAcv) TABLESPACE UC4_INDEX; CREATE INDEX NK_MQ1CP006_Prio ON MQ1CP006 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX; CREATE INDEX NK_MQ1CP006_SchTime ON MQ1CP006 (MQCP_SchedTime) TABLESPACE UC4_INDEX;
CREATE TABLE MQ2CP006 ( MQCP_PK NUMBER(38,0) NOT NULL, MQCP_System VARCHAR2 (8 CHAR) NULL, MQCP_CAddr VARCHAR2 (32 CHAR) NULL, MQCP_CSRName VARCHAR2 (8 CHAR) NULL, MQCP_CAcv NUMBER(38,0) NULL, MQCP_BAddr VARCHAR2 (32 CHAR) NULL, MQCP_BSRName VARCHAR2 (8 CHAR) NULL, MQCP_BAcv NUMBER(38,0) NULL, MQCP_FAddr VARCHAR2 (32 CHAR) NULL, MQCP_LogAddr VARCHAR2 (32 CHAR) NULL, MQCP_PhysAddr VARCHAR2 (32 CHAR) NULL, MQCP_BTable VARCHAR2 (8 CHAR) NULL, MQCP_SchedTime DATE NULL, MQCP_Status NUMBER(38,0) NULL, MQCP_Priority NUMBER(38,0) NULL, MQCP_DRole VARCHAR2 (32 CHAR) NULL, MQCP_LAddr VARCHAR2 (32 CHAR) NULL, MQCP_Len NUMBER(38,0) NULL, MQCP_Msg BLOB NULL, CONSTRAINT PK_MQ2CP006 PRIMARY KEY ( MQCP_PK ) USING INDEX TABLESPACE UC4_INDEX ) LOB (MQCP_Msg) STORE AS (ENABLE STORAGE IN ROW CACHE) TABLESPACE UC4_DATA ENABLE ROW MOVEMENT NOCOMPRESS; CREATE SEQUENCE SQ_MQ2CP006 INCREMENT BY 1 START WITH 1 MAXVALUE 2147483647 MINVALUE 1 CYCLE CACHE 1000 NOORDER; CREATE INDEX NK_MQ2CP006_BAcv ON MQ2CP006 (MQCP_BAcv) TABLESPACE UC4_INDEX; CREATE INDEX NK_MQ2CP006_Prio ON MQ2CP006 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX; CREATE INDEX NK_MQ2CP006_SchTime ON MQ2CP006 (MQCP_SchedTime) TABLESPACE UC4_INDEX;

Note:It is not needed to add more tables for WPs. This is only necessary for CPs.

Outcomes