Enabling ASE Real-Time Messaging Services

Enable real-time messaging services at your Adaptive Server Enterprise data server.

1. Set up an sa role for the administrator.
2. Install the real-time messaging services stored procedures:

   isql -I$SYBASE/$SYBASE_ASE/scripts/installmsgsvss

3. Establish an isql session to your ASE data server:

   isql -Usa -P<password> -S<server>

4. Enable Real-Time Messaging with the sp_configure stored procedure.

   To enable Real-Time Messaging for one provider only, specify tibco_jms or ibm_mq:

   sp_configure "enable real time messaging", 1, tibco_jms

   To enable Real-Time Messaging for all providers, do not specify a provider:

   sp_configure "enable real time messaging", 1

5. Grant a messaging role:

   grant role messaging_role to sa

6. To verify ASE real-time messaging features, start your messaging server, and transmit a simple message.

   For example:

   
   

   • select msgsend("hello","tibco_jms:tcp://<hostname>:7222?queue=q.sample")

   • select msgrecv("tibco_jms:tcp://<hostname>:7222?queue=q.sample")

7. Register a JMS provider:

   For example:

   sp_msgadmin 'register', 'provider', myTibcoJMS, TIBCO_JMS', 'TIBCO_JMS', 'tcp://localhost:7222'

Next 

See the ASE Messaging Services User's Guide for Adaptive Server Enterprise.

See Installation and Release Bulletin for Sybase Real-Time Data Services.

Also see the TIBCO and IBM WebSphere MQ user documentation.

---

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com