DataStage - Data Integration

 View Only
  • 1.  DataStage in active-passive server

    Posted Mon March 21, 2022 10:17 AM
    Hello.

    I need to install Information Server(DataSatage) in active-passive high availability, but I have some doubts, the IBM documentation is a little confusing.

    Has anyone installed it and can help me?

    In a two-server active-passive high availability configuration, two computers share a storage device. I will install metadata repository tier, engine tier, and services tier all by installed.

    1. Run the InfoSphere Information Server installation program on the primary server and When prompted by the installation program, specify the virtual host name.
    - Virtual Host is the storage device?
    2. Do I need to Run the InfoSphere Information Server installation program on the secondary server?
    3. Do the primary and secondary servers need to have the same FS structure for the DataStage, right? And how is the FS structure in storage, the installer do it?
    4. Do the clients point to the ip of the active node that will redirect to storage?

    Has anyone installed and have a step by step. 

    Thank you so much.

    ------------------------------
    Rafael Nery
    ------------------------------


  • 2.  RE: DataStage in active-passive server

    IBM Champion
    Posted Tue March 22, 2022 03:26 AM

    Hi Rafael

    Active-Passive configuration requires cluster os configuration. When you have PowerHA (HACMP) on AIX or Tivoli System Automation in Linux you will get computer group name (service name, in installation process - Virtual Host Name) which will be updated in DNS automatically during cluster switchover.

    Additional element is to setup common storage (available from both servers or mirrored automatically between them). You install IS on that storage and in the second machine you have to create users/groups with the same uid/guid. You will not install IS on the second machine.

    Only DB2 shouldn't be setup in Active-Passive. You should install DB2 on primary device. Create secondary instance on Secondary device and setup HADR. It will be work in Active-Standby mode.

    For client connection you will be use virtual host name (service name from cluster setup) instead of physical host names.

    It is great free RedBook about architecture setup - you should read it also: https://www.redbooks.ibm.com/redbooks/pdfs/sg248028.pdf

    Ibm remove preview
    View this on Ibm >

    Ibm remove preview
    View this on Ibm >






    ------------------------------
    Marcin Molak
    ------------------------------



  • 3.  RE: DataStage in active-passive server

    Posted Tue March 22, 2022 12:54 PM

    The active passive mode install is described here:
    Creating a two-server active-passive high availability configuration

    As mentioned in the document "A high availability software product is installed on both servers, such as IBM Tivoli® System Automation for Multiplatforms on Linux® or UNIX systems or Microsoft Cluster Service (MSCS) on Microsoft Windows systems"  I think from your questions you might be missing the need for that software product.

    This means you will have 3 ips and 3 hostnames for the two servers.  Of the three pairs 1 ip/1hostname pair is "floating" - that "floating"  is coordinated by the HA software product you use. All three pairs can be in dns.

    Information Server is installed once on the storage through one of the servers, typically primary. The storage can either be shared (e.g NAS) or mounted on only the currently live side (e.g SAN); You will need to provide scripts to the your HA software product of choice that on failover do shutdown/unmount on the previously live side and to  mount / startup onto the will-be live side. There will be a short outage during failover.

    In regard to your questions, hopefully that helps but taking each in turn:

    1. The virtual hostname is the floating hostname above
    2.  One install
    3. There is only one storage structure and one install.
    4. Correct - the hostname you enter in the clients (inc browser) is the floating hostname.

    My personal experience is that nowadays this configuration is perhaps less common, in virtualization settings the native capabilities of the virualisation can be considered to be  used instead.

    For example if using VMware , vMotion and/or Site Recovery Manager can be considered to be  used as part of  HA/DR solution; that can have zero outage on vMotion when setup correctly.

    What is vMotion? | Live Migration of Virtual Machines | VMware

    VMware Site Recovery Manager: Disaster Recovery Software





    ------------------------------
    Mark Lee
    ------------------------------



  • 4.  RE: DataStage in active-passive server

    Posted Tue March 22, 2022 01:45 PM
    Thank you so much.

    Obrigado, Thank You.
     
    Rafael Nery
    Messaging & Integration
    IT Specialist Certified: InfoSphere DataStage Server; IBM MQ; Message Broker.
    GI_CBA_FIN_S1 Squad

    1572631244193 

     

    1572631343036
    E-mail: rnery@kyndryl.com






  • 5.  RE: DataStage in active-passive server

    Posted Tue March 22, 2022 01:55 PM
    Thank you so much.

    ------------------------------
    Rafael Nery
    ------------------------------