DataStage - Data Integration

 View Only
Expand all | Collapse all

Support for Environment Variables creation in DFD and Next Gen Datastage

  • 1.  Support for Environment Variables creation in DFD and Next Gen Datastage

    InnerCircle
    Posted Tue December 21, 2021 02:01 AM
    Hi All,

    Hope you everyone is doing good.

    I am looking for a help in creating a new environment variables in Data flow designer(CP4D 3.5) .

    I have tried creating it from the parameter set options by selecting environment variable. However there is no option for creating a new environment variable.

    Observations : After importing the ISX files , jobs imported successfully however dependencies like parameter sets and environment variables are not imported, need to import the parameter sets separately. 

    Environment variables cannot be imported.

    Any solution for this issue in Data Flow designer.

    Storage is still not configured for CP4D 3.5.

    I need to add or create a new environment variables in Data Flow designer(using CP4D 3.5).

    I am trying to migrate jobs from 11.3(out of support) to Data Flow Designer (CP4D 3.5) .

    Thanks and Regards
    Shahid


    ------------------------------
    Mohammad Shahid B
    ------------------------------


  • 2.  RE: Support for Environment Variables creation in DFD and Next Gen Datastage

    Posted Wed December 22, 2021 05:42 PM
    Hi

    DFD don't have all the capabilities of DataStage & QualityStage Designer yet as of CPD V3.5.x.

    It is recommended to use the DataStage & QualityStage Designer and this is the link on how to configure it to access CPD V3.5.x - https://www.ibm.com/support/pages/node/6356623

    DFD and the DataStage Windows Client is officially sunset in DS V4.0.2 and this is the link to the roadmap of new Client - https://bigblue.aha.io/published/ba449c63c128819d8a0d08520fb1c7e7?page=4

    Based on above roadmap, the new Client cannot replace DataStage Windows Client until late FY2022.

    You need to know what capabilities you need before moving to DS V4.0.2.

    A good way to try out DS V4.0.x is to use the "free" Lite Tier of DSaaS to try out the new Client - https://cloud.ibm.com/catalog/services/datastage

    ------------------------------
    HOW MING YONG
    ------------------------------



  • 3.  RE: Support for Environment Variables creation in DFD and Next Gen Datastage

    Posted Thu December 23, 2021 03:29 AM
    Edited by Mark Lee Thu December 23, 2021 03:29 AM
    Yes.

    +if you are ok with the associated risks  of working from the command line, the dsadmin command is available in the conductor pod

    https://www.ibm.com/docs/en/iis/11.7?topic=interface-commands-administering-projects

    [root@api ~]# oc project cpd-instance
    [root@api ~]# oc rsh is-en-conductor-0
    Defaulted container "iis-en-conductor" out of: iis-en-conductor, load-data (init), wait-services (init)
    sh-4.4$ id
    uid=10032(dsadm) gid=1000(dstage) groups=1000(dstage),0(root),10(wheel)
    sh-4.4$ cd /opt/IBM/InformationServer/Server/DSEngine
    sh-4.4$ . ./dsenv
    sh-4.4$ cd bin
    sh-4.4$ ./dsadmin -listprojects
    ANALYZERPROJECT
    dstage1
    .. etc..


    sh-4.4$ ./dsadmin -listenv dstage1
    DSIPC_OPEN_TIMEOUT=30
    APT_DEFAULT_TRANSPORT_BLOCK_SIZE=131072
    APT_LATENCY_COEFFICIENT=5
    APT_BUFFERING_POLICY=AUTOMATIC_BUFFERING
    APT_BUFFER_MAXIMUM_TIMEOUT=1
    ..

    etc

    accepting the risk.. dsadmin can be used to create and delete env variables that way too.

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