Automic Workload Automation

  • Private Community

  • 1.  Adding Additional CPs (above the default 5) - MS SQL

    Posted Jan 23, 2014 11:47 AM

    Hi All, here's the SQL statement for adding additional CPs (above the default 5)

    MSSQL

    CREATE TABLE MQCP006 (
    MQCP_PK int IDENTITY NOT NULL,
    MQCP_System varchar (8) NULL,
    MQCP_CAddr varchar (32) NULL,
    MQCP_CSRName varchar (8) NULL,
    MQCP_CAcv int NULL,
    MQCP_BAddr varchar (32) NULL,
    MQCP_BSRName varchar (8) NULL,
    MQCP_BAcv int NULL,
    MQCP_FAddr varchar (32) NULL,
    MQCP_LogAddr varchar (32) NULL,
    MQCP_PhysAddr varchar (32) NULL,
    MQCP_BTable varchar (8) NULL,
    MQCP_SchedTime datetime NULL,
    MQCP_Status int NULL,
    MQCP_Priority int NULL,
    MQCP_DRole varchar (32) NULL,
    MQCP_LAddr varchar (32) NULL,
    MQCP_Len int NULL,
    MQCP_Msg varbinary (max) NULL,
    CONSTRAINT PK_MQCP006 PRIMARY KEY NONCLUSTERED ( MQCP_PK) )
    GO

    CREATE INDEX NK_MQCP001_BAcv ON MQCP006(MQCP_BAcv)
    GO

    CREATE CLUSTERED INDEX NK_MQCP001_Prio ON MQCP006(MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status)
    GO


  • 2.  Adding Additional CPs (above the default 5) - MS SQL

    Posted Jun 03, 2016 12:57 PM
    For version 11.2 the sql for this is a little different, just in case someone was looking for it.