Configuring Adaptive Server for MQ

A Q engine uses the same amount of memory resources that Adaptive Server engines use. Messaging operations fail if you do not have enough Q engines. You cannot run any Adaptive Server sessions on the Q engine.

Q engines appear in sysengines, with a “_q” appended to their status:

To bring a Q engine online, use the sp_engine stored procedure; an existing sp_engine works on Q engines. Use sp_configure "max online Q engines" to specify the maximum number of engines online.