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.  File lock issues on append

    Posted 05/13/05 02:19 AM

    Originally posted by: SystemAdmin


    Hello!

    we are discussing the following scenario: One event triggered map is producing output data as append to a file. A Second map, triggered by other events is using this file as input data, and deleting it on success

    Does anybody know, if the TX file mechanism provides enough security in this issue: Is there any danger that the second map gets corrupt input data, as the file is currently written by the first map.

    We are using 6.7.1 on HP-UX 11.

    Thanks a lot for your help.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: File lock issues on append

    Posted 05/13/05 03:05 AM

    Originally posted by: SystemAdmin


    The resource manager should be able to handle this (it won't let 2 maps write to the same destination at once etc.) but I'd make sure you test it lots!
    Cheers, Olly.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: File lock issues on append

    Posted 05/13/05 06:09 AM

    Originally posted by: SystemAdmin


    The resource manager will protect against both maps trying to update the file at the same time but for safety I would suggest that you have a map that simply grabs that file and renames it when it is time for the second map to use it. Provides a cleaner separation and should reduce long resource wait situations.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: File lock issues on append

    Posted 05/13/05 07:52 AM

    Originally posted by: SystemAdmin


    You might have to add retries on the maps since the RM will have the file locked while the other map is using it. Better option would be to send the data to a DB to be read when the second map gets triggered.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender