Automic Workload Automation

  • Private Community

  • 1.  How to increase CP's and WP's in the existing environment

    Posted Apr 26, 2018 10:11 AM

    Hello All,

     

    We are on V12.1. We have setup our environment using ONE-Installer and by default we have 2CP's and 5 Wp's are running ,if I'm not wrong. But can we increase more CP's and WP's based on the load or may be due to increase in the number of agents. Please let me know how can we do this.

     

    Thanks in advance,

    Srujan.



  • 2.  Re: How to increase CP's and WP's in the existing environment

    Posted Apr 26, 2018 01:53 PM

    Hi

     

    If you run Service Manager simply start more WP and CP Processes

     

    Up from V12.1 it should be possible starting more CPs than 5 without creating the necessary tables with an additional SQL script.

     

    cheers, Wolfgang



  • 3.  Re: How to increase CP's and WP's in the existing environment

    Posted Apr 26, 2018 02:16 PM

    Okay, we can increase CP's by duplicating the running process in service manager right?

     

    And for V12.0, do we need to write SQL script for that, if yes, can I get the sample script ?

     

    Thanks,

    Srujan.



  • 4.  Re: How to increase CP's and WP's in the existing environment
    Best Answer

    Posted Apr 26, 2018 02:53 PM

    Hi patve03,

     

    Yes, in AE v12.1 the CP all you need to do is duplicate it in the services manager and start it (and the table will get auto created).

     

    In AE v12.0, you will need to manually create the tables if you want to have more than 5 CP. 

     

    The script for how the system created the CP can be found in the media file in the DB folder.... uc_ddl.sql file

     

    Below is is an example of the SQL from the media file db/oracle/12.0/uc_ddl.sql  .... For each CP there an MQ1CP### and a MQ2CP###

    You can take this and replace the ### with the CP number you want to create. 

     

    CREATE TABLE MQ1CP001  (
            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_MQ1CP001 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_MQ1CP001
            INCREMENT BY 1 START WITH 1 MAXVALUE 2147483647
            MINVALUE 1 CYCLE CACHE 1000 NOORDER;
    CREATE   INDEX NK_MQ1CP001_BAcv ON MQ1CP001 (MQCP_BAcv) TABLESPACE UC4_INDEX;
    CREATE   INDEX NK_MQ1CP001_Prio ON MQ1CP001 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX;
    CREATE   INDEX NK_MQ1CP001_SchTime ON MQ1CP001 (MQCP_SchedTime) TABLESPACE UC4_INDEX;

     

    CREATE TABLE MQ2CP001  (
            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_MQ2CP001 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_MQ2CP001
            INCREMENT BY 1 START WITH 1 MAXVALUE 2147483647
            MINVALUE 1 CYCLE CACHE 1000 NOORDER;
    CREATE   INDEX NK_MQ2CP001_BAcv ON MQ2CP001 (MQCP_BAcv) TABLESPACE UC4_INDEX;
    CREATE   INDEX NK_MQ2CP001_Prio ON MQ2CP001 (MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX;
    CREATE   INDEX NK_MQ2CP001_SchTime ON MQ2CP001 (MQCP_SchedTime) TABLESPACE UC4_INDEX;


  • 5.  RE: Re: How to increase CP's and WP's in the existing environment

    Posted Sep 04, 2020 04:47 AM
    Hello , 

    We are using AWI 12.3.0  and we want to increase CP and JCP. 

    Do we also need to run the script or only duplicate it in the services manager and start it (and the table will get auto created) will work ? 

    Regards,
    Viral
    Original Message


  • 6.  RE: Re: How to increase CP's and WP's in the existing environment

    Posted Sep 05, 2020 04:36 AM
    Hello,
    Also make sure that CP ports are define in ucsrv.ini
    Original Message


  • 7.  Re: How to increase CP's and WP's in the existing environment

    Posted Apr 26, 2018 03:02 PM

    Excellent !! 

    Same goes with other processes(WP,DWP,JWP,JCP),correct?

    Should we restart anything after creating the tables in the SQL script or else not required?

     

    Regards,

    Srujan. 



  • 8.  Re: How to increase CP's and WP's in the existing environment

    Posted Apr 26, 2018 04:17 PM

    Just CP and JCP need new tables. All the others share a common MQXXX table.

     

    Here is a look at the schema:
    AE V12 Schema