IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  DataStage TX 8.0 vs. DataStage TX 671 performance

    Posted 12/20/05 09:42 AM

    Originally posted by: SystemAdmin


    Has anyone noticed a performance degradation when migrating from 671 to 8.0? With large files running via the command server, we have noticed that 8.0 is much slower than 6.7.1 with regards to map run times given the same command line options.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: DataStage TX 8.0 vs. DataStage TX 671 performance

    Posted 12/20/05 10:04 AM

    Originally posted by: SystemAdmin


    In almost every case, 8.0 should be faster. Have you tried the map profiler and page size & count optimizer?

    Are you on the same server with both installs? Same ulimits? What OS?

    Are you validating XML data?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: DataStage TX 8.0 vs. DataStage TX 671 performance

    Posted 12/20/05 10:23 AM

    Originally posted by: SystemAdmin


    OS: AIX 5.2

    Same Ulimits.

    Have used the recommended Page Size setting with dsxtxpage utility - although we ran it with a smaller file. Ran the same file with same Page Size settings under 671 and 8.0.

    Have not used the Profiler on this map yet. That is the next step.

    It is not XML data.
    It is a large 837 Institutional file.

    We have done a thorough evaluation of running different types of files through 671 and 8.0. Most of the scenarios - we found 671 to be faster than 8.0.

    The above results are similar to when we did an evaluation with 751. This was reported to Tech Support at that time. That is the one of the reasons we did not upgrade immediately to 751.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: DataStage TX 8.0 vs. DataStage TX 671 performance

    Posted 12/21/05 06:49 AM

    Originally posted by: SystemAdmin


    Suggest sending test case to support so this can be passed on to engineering.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender