Statement to create a new MQCP Table on Oracle

Document ID : KB000088371
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Statement to create a new MQCP Table on Oracle.

Investigation

On each Server start, the following message appears:

U0003594 UCUDB Ret: '3590' OpCode: 'EXEC' SQL Stmnt: 'DELETE FROM MQCP006'
U0003590 DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00942: table or view does not exist'

Resolution:
Following Statement adds an additional MQCP table to the version 9 AE system version.

Note:
If more than 6 CPs, change every occurrence in the statement below from CP006 to CP007, CP008 ... ascending.
 

CREATE TABLE MQCP006  (
         MQCP_PK INTEGER NOT NULL,
         MQCP_System VARCHAR2 (8) NULL,
         MQCP_CAddr VARCHAR2 (32) NULL,
         MQCP_CSRName VARCHAR2 (8) NULL,
         MQCP_CAcv INTEGER NULL,
         MQCP_BAddr VARCHAR2 (32) NULL,
         MQCP_BSRName VARCHAR2 (8) NULL,
         MQCP_BAcv INTEGER NULL,
         MQCP_FAddr VARCHAR2 (32) NULL,
         MQCP_LogAddr VARCHAR2 (32) NULL,
         MQCP_PhysAddr VARCHAR2 (32) NULL,
         MQCP_BTable VARCHAR2 (8) NULL,
         MQCP_SchedTime DATE NULL,
         MQCP_Status INTEGER NULL,
         MQCP_Priority INTEGER NULL,
         MQCP_DRole VARCHAR2 (32) NULL,
         MQCP_LAddr VARCHAR2 (32) NULL,
         MQCP_Len INTEGER NULL,
         MQCP_Msg BLOB NULL,
         CONSTRAINT PK_MQCP006 PRIMARY KEY
         (
                 MQCP_PK
         ) USING INDEX  TABLESPACE Automic_INDEX
) LOB (MQCP_Msg) STORE AS (ENABLE STORAGE IN ROW CACHE) TABLESPACE Automic_DATA;
CREATE SEQUENCE SQ_MQCP006
   INCREMENT BY 1 START WITH 1 MAXVALUE 999999999
         MINVALUE 1 CYCLE CACHE 1000 NOORDER;
CREATE   INDEX NK_MQCP006_BAcv ON MQCP006 (MQCP_BAcv) TABLESPACE Automic_INDEX;
CREATE   INDEX NK_MQCP006_Prio ON MQCP006 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE Automic_INDEX;