Statement to create a new MQCP Table

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Statement to create a new MQCP Table.

On starting the Server the following messages appear:  
 

 

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

In order to add the MQCP006 table you need the statement we provide.  It will NOT make the message disappear.  It will only change ascending to the next MQCP list (e.g. MQCP007, MQCP008...)

However, the message cause no adverse effects.

Environment

Release: AOATAM99000-8.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

 

NOTE:  This solution is for Oracle only, if you need it for MSSQL or DB2 you can either customize it, or contact Automic Support.
 

Following Statement adds an additional MQCP table to your system.

NOTE:  If you need more than 6 CPs you have to change every occurance (in the statement bolded below) of CP006 to CP007, CP008 ... ascending. The Statement only creates one CP Table, if you need more than one additional CP, you have to run it for each desired CP by changing the bold entries.

 

Version 8.00A:

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 UC4_INDEX
) LOB (MQCP_Msg) STORE AS (ENABLE STORAGE IN ROW CACHE) TABLESPACE UC4_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 UC4_INDEX;
CREATE   INDEX NK_MQCP006_Prio ON MQCP006 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX;

Version 10:

CREATE TABLE MQCP006 (

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_MQCP006 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_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 UC4_INDEX;
CREATE INDEX NK_MQCP006_Prio ON MQCP006 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX;