sp_config 'enable real time messaging'

Description

Enables, disables, or displays current real time messaging configuration.

Syntax

sp_configure “enable real time messaging”
	, [ enable_or_disable ], [ ibm_mq | tibco_jms ]

Parameters

enable_or_disable

specifies whether or not to enable or disable the 'real time messaging' option. Valid values are:

1 – enables real-time messaging.
0 – disables real-time messaging.

If omitted, the current “real time messaging” configuration is returned.

ibm_mq: enables “real time messaging” for IBM MQ only. This option is ignored if enable_or_disable is 0 (zero).

tibco_jms: enables “real time messaging” for TIBCO JMS only. This option is ignored if enable_or_disable is 0 (zero).

Examples

Example 1

Enables real time messaging for all providers :

sp_configure "enable real time messaging",1

Example 2

Enables real-time messaging for MQ only:

sp_configure "enable real time messaging",1,ibm_mq

Using this stored procedure overwrites your previous setting. For example, if you had previously set real-time messaging to TIBCO JMS, running this stored procedure disables your TIBCO JMS setting as it turns on IBM MQ.

Example 3

Enables real-time messaging for TIBCO only:

sp_configure "enable real time messaging",1,tibco_jms

Example 4

Disables real-time messaging:

sp_configure "enable real time messaging",0

Usage

The enable_or_disable parameter works only if the following are installed and set up correctly:

The appropriate LD_LIBRARY_PATH for your platform
The provider DLL libraries
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.