Automic Workload Automation

  • Private Community

  • 1.  Automatic creation of CP tables

    Posted Mar 12, 2018 07:04 AM

    In the AWA 12.1 Release Highlights it is said that:

    "...A new table is now automatically created in the database when you are using more than five CPs. No manual intervention is required anymore."

    Has anyone tried this and able to confirm this is working correctly.




  • 2.  Automatic creation of CP tables
    Best Answer

    Posted Mar 12, 2018 11:12 AM
    Dear Keld_Mollnitz

    I can confirm that this is true.

    - Configure the Port Range in the UCSRV.ini
    - Add the CP to the Servicemanager / Dialog

    Just tested this with V12.1.1.

    Best Regards
    Christian Glaser



  • 3.  Automatic creation of CP tables

    Posted Mar 22, 2018 12:46 AM
    Hi Keld_Mollnitz,

    I just installed a new 12.1.1 on Linux/Oracle and as soon as you start CP006 you can see the following message in the CPsrv_log_006_00.txt

    20180321/121449.406 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00942: table or view does not exist'
    20180321/121449.609 - U00003101 CP 'V121OU#CP006' connected for the first time. Automatically created 'MQ1CP006' table.

    Cheers,
    Alexander



  • 4.  Automatic creation of CP tables

    Posted Mar 22, 2018 05:44 AM

    Thanks Christian and Alexander,

    I seem to recall that someone in the Community reported this not be working properly, but it must have fixed in a hotfix or similar...

    Great!



  • 5.  Automatic creation of CP tables

    Posted Mar 22, 2018 05:58 AM
    Hi,

    think you refer to Carsten Schmitz post here :
    https://community.automic.com/discussion/comment/36970#Comment_36970

    We've had that problem after a ZDU upgrade. The MQ tables were created, but the corresponding db sequences were missing.Took us a while to figure that out.

    Since then we made 2 or 3 ZDUs, but haven't had that problem anymore.


  • 6.  Automatic creation of CP tables

    Posted Mar 23, 2018 03:55 PM
    Additional information: not only is the MQ1CP006 automatically created, also the MQ2CP006 gets created during this process. That's important for any future ZDU on this system.


  • 7.  RE: Automatic creation of CP tables

    Posted Jan 21, 2021 05:55 AM
    If you use non-standard tablespace names, and plan to use more than 5 CPs, be sure to update the initial data file uc_ini.txt (and if necessary, in UC_DBSYN). These statements (as of 12.3.4 HF2) contain hard-coded tablespace names.
    Original Message