Configuring RTMS

To install Sybase RTMS, simply install Adaptive Server, including the messaging license that RTMS requires (ASE_MESSAGING_TIBJMS for TIBCO JMS and ASE_MESSAGING_IBMMQ for IBM WebSphere MQ) . Follow the instructions in the installation guide for your platform. You must install Adaptive Server before you can configure RTMS.

StepsConfiguring the server to use RTMS

  1. If you are using:

    NoteThe following must be correct for in order to enable real-time messaging:

    • The path to your shared library environment

    • The DLL libraries provided by TIBCO or IBM

    • SYBASE licenses

    • The SYBASE interface libraries from the CD

    See the Real-Time Data Services Installation and Release Bulletin for details on paths and file names.

  2. Install the RTMS stored procedures:

    isql -i$SYBASE/$SYBASE_ASE/scripts/installmsgsvss
    
  3. Grant messaging_role to the appropriate Adaptive Server logins:

    grant role messaging_role to <login>
    
  4. Increase memory configuration:

    sp_configure 'messaging memory', <# of pages>
    

    The default value is 400 pages. Increase this value if your application requires more memory.

  5. Add the local server, if you have not already:

    sp_addserver <local server name>, local
    

    You must restart Adaptive Server for this command to take effect.

  6. If you are using MQ, configure Q engines—which are Adaptive Server engines that perform only MQ client API calls:�

    �sp_configure "max online engines", 11�
    sp_configure "max online Q engines", 1�
    sp_configure "number of Q engines at startup", 1�
    

    If the existing max online engines parameter is set to 10, this example sets it to� 11 to allow one Q engine.

    You must restart Adaptive Server for this change to take effect.