Other Software and Data

 View Only
  • 1.  Enforcing Worker Limits - ConnectCDC to Azure SQL DBs

    Posted 02-16-2023 16:21

    I am trying to synchronise a number of large tables from DB/400 to Azure SQL DB. These tables are just short of a billion rows each. 

    When I try to start the "copy phase" fails because it exceeds the worker limitations of Azure SQL.

    We have a v8 cores with 32 Gb of memory as a standard configuration.


    Can someone suggest a solution.



    ------------------------------
    Brian Green
    People's Choice Credit Union
    GREENWICH NSW
    ------------------------------


  • 2.  RE: Enforcing Worker Limits - ConnectCDC to Azure SQL DBs

    Employee
    Posted 03-08-2023 05:04

    Brian

    You have posted in the Community FAQs which is a community to answer questions on how to use the Community. Product questions should be posted in the relevant Product Community. If you don't see your product listed, then you can post in the product community called Other Software and Data.

    Have you viewed the product documentation for Connect CDC from the Support Website within the products section

    https://support.precisely.com/find-support-by-product/

    There are 2 Connect CDC products which can be found here

    https://support.precisely.com/products/connect-cdc-formerly-sqdata/
    https://support.precisely.com/products/connect-cdc-formerly-mimix-share/

    You can also search the knowledge base and documentation from the Precisely Support homepage https://support.precisely.com/. Logging into the Customer Community will give you access to more knowledge base articles than are available by not logging in.

    If you cannot find what you are looking for, then I would suggest you contact Support by raising a case online from here

    https://support.precisely.com/login-sign-up/

    or using the contact information here

    https://support.precisely.com/contact/



    ------------------------------
    Lee Henty
    Precisely Software Inc.
    Reading
    ------------------------------