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.  Oracle AQ as source

    Posted 10/30/08 12:26 PM

    Originally posted by: Kepa_Screen


    Hi:

    We are using a map in an Event Server listening to an Oracle AQ. This is command used for

    GET
    "-MDQ %mdq_file% -DBNAME INTERF -Q C_SIC_PPAL_O -R S_ITF_EAI -LSN 3 -HDR -QTY 100"

    SourceRule is Burst, fetchUnit is 1.
    We retrieve Header from OracleAQ.

    We are having a problem, because multiple Oracle sessions are enqueueing on Source Queue. This queue is "sorted" by priority, enq_time.

    Does any one know how the adapter dequeues the messages ? We know it's FIFO, but does it follow "sort rules" specified at Oracle ( queue creation script ) ??

    We see -P for priority, but it's only for target, not for source. ...And we are having some trouble because lots of sources put data at our source queue, and priorities are not being respected.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


Related Content