Db2 Tools for zOS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

IDAA - IBM Db2 Analytics Accelerator - How to check synchronization of data between two accelerators ?

  • 1.  IDAA - IBM Db2 Analytics Accelerator - How to check synchronization of data between two accelerators ?

    Posted Wed September 04, 2024 01:17 PM

    Hi,

    Can you someone tell me the steps to check the data synchronization between two accelerators ?

    I am having two accelerators defined in my IDAA alias. Recently due to an issue, I had to stop acceleration for one of the problematic accelerator. Now, the problem is resolved. I am planning to perform the following steps,

    1. Add the accelerator back to alias
    2. Perform LOAD
    3. Check the data synchronization between two accelerators
    4.  Start the acceleration

    How can the 3rd step *data synchronization between two accelerators* can be validated by Data Studio ?

    Many Thanks



    ------------------------------
    Rajesh Chandran
    ------------------------------


  • 2.  RE: IDAA - IBM Db2 Analytics Accelerator - How to check synchronization of data between two accelerators ?

    Posted Thu September 05, 2024 06:32 AM

    Hi Rajesh, 

    You can use -DISPLAY STATS command (Db2) - IBM Documentation command with SCOPE(GROUP) option. The output will tell the status of Integrated synchronization for each IDAA targets from Data Sharing Group. 

    Regards, Cuneyt 



    ------------------------------
    MEHMET CUNEYT GOKSU
    ------------------------------