Saturday, 19 September 2015

ERROR HANDLING SCENARIO


1.INPUT
2. SUB-FLOW


3.BACK TO MAIN FLOW


4.UPDATES THE ERROR IN THE DATABASE WITHIN SUBFLOW AND ROLLS BACK BY THROW


5.RETURNS TO CATCH TERMINAL OF INPUT UPON ROLLBACK AND UPDATES OUTPUT1 QUEUE WITH THE FAILED MESSAGE

NOTE: IF THE CONDITION Body.Staff.StaffNumber <='10' IN CheckValidStaffNumber NODE IS SATISFIED THEN UpdateStaffDatabase node hits and computes accordingly.

Friday, 14 August 2015

WebSphere MQSC commands for MQ

 Start MQ Explorer                                                -            STRMQCFG

Display Version Information                                 -            DSPMQVER

Display Queue Managers                                    -            DSPMQ

Display command server                                     -            DSPMQCSV (Queue Manager Name)
(display the status of the command server
for the specified queue manager;Starting,Ending
Running,Stopped)

End command server                                          -            ENDMQCSV (Queue Manager Name)

START command server                                     -           STRMQCSV (Queue Manager Name)

Create Queue Manager                                      -            CRTMQM (Queue Manager Name)

Delete queue manager                                       -            DLTMQM (Queue Manager Name)

Start Queue Manager                                  -           STRMQM (Queue Manager Name)

End Queue Manager                                   -           ENDMQM (Queue Manager Name)


Run MQSC commands                               -           RUNMQSC (Queue Manager Name)
(defining, altering, or deleting a local queue object)

Define a Local Queue                                  -              DEFINE QLOCAL  (Queue Name)
Define a Transmission Queue            -   DEFINE QLOCAL (Transmission queue Name)  
                                                                                                            USAGE  (XMITQ)

Define a Remote Queue Definition   -                    DEFINE QREMOTE (Remote Queue   
       Definition Name) RQMNAME (Remote Queue Manager Name)  RNAME (Remote
                                                       Queue Name)  XMITQ(Transmission Queue Name)

Run Channel Initiator                                    -   RUNMQCHI [-m QMgrName] [-q InitQ]

Define a Sender Channel    -                                  DEFINE CHANNEL (Channel name)
          CHLTYPE (SDR)  TRPTYPE (TCP) CONNAME (‘LOCALHOST(Remote Queue
                                              Manager Listener)’) XMITQ (Transmission Queue Name)

Define a Receiver Channel  -               DEFINE CHANNEL (Channel name) CHLTYPE
                                                                                             (RCVR)   TRPTYPE(TCP)
                                                                                                               

Define a Listener                  -              DEFINE LISTENER (Listener Name) TRPTYPE
                                                                                         (TCP)  PORT (Port Number)                        

Start a Listener                     -             RUNMQLSR -t (TCP)

End Listener                         -             ENDMQLSR

Start Trigger Monitor            -              RUNMQTRM -q(Initiation Queue Name)
                                                                              -m(Queue Manager Name)

Run Dead-Letter Queue Handler                      -          RUNMQDLQ


Start Trace                                                           -          STRMQTRC

End Trace                                                            -          ENDMQTRC

Display Formatted Trace                                     -           DSPMQTRC