Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are a few ways to do this.</p> <ol> <li>Set the application up under Windows control (since you mentioned the QMgr is on Windows.) The app would run as a service, with recovery options to restart it if the service fails. The application would be programmed (or configured in the case of Q) to process the queue using GETs with a VERY long wait period. Some additional error handling is required to do something sensible when the QMgr is not available. This works great for copying messages to multiple queues but isn't appropriate for queue-to-file since the file would never close.</li> <li>Run the application as a WebSphere MQ service. Defining the <code>SERVICE</code> object using <code>CONTRIL(QMGR)</code> causes MQ to start the service when the QMgr boots and stop it when the QMgr is shut down. Since the service is a child process of the QMgr, no need to worry about how to handle errors when the QMgr isn't available.</li> <li>Trigger the program based on non-zero queue depth. Define a process object describing the command to be executed, enable triggering on the queue with <code>TRIGTYPE(FIRST)</code> and run a trigger monitor. Whenever the queue has depth > 0 and no open input handles, the process object fires and executes the command. The thing you start must know how to parse the command line so the easiest thing to do if you have someone else's executable is use a script to start it. The script parses the trigger message and fires off the executable. Or perhaps the script ignores the trigger message and just runs the exe. I generally use Korn Shell or Perl and both are available on Windows.</li> </ol> <p>I wrote an article showing how to keep event queues from filling using a triggered version of Q. The article assumes you want the queues to remain mostly full so uses triggering on depth of about 80%. The same techniques could be used (in a much simpler implementation, by the way) to fire off the Q program whenever the queue depth became non-zero.</p> <p><strong>UPDATE</strong><br> Probably should have linked the article. ;-)<br> <a href="http://www.ibm.com/developerworks/websphere/techjournal/1103_mismes/1103_mismes.html" rel="nofollow">Mission:Messaging: Easing administration and debugging with circular queues</a> </p>
    singulars
    1. This table or related slice is empty.
    1. POCalling a .EXE from Websphere-MQ
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UST.Rob
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCalling a .EXE from Websphere-MQ
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload