Sybase Real-Time Events

Perform the following tasks to check if the Sybase Real-Time Events components have been successfully installed.

RepConnector

To verify if RepConnector is installed successfully for your application server:

For EAServer – go to $SYBASE/EAServer and check if the repra directory exists.

For BEA Weblogic – go to the Weblogic_installation_directory and check if the repra directory exists.

Replication Server

To verify if the Replication Server subcomponent has been successfully installed, see “Replication Server”.

Replication Agent

To verify if the Replication Agent subcomponent has been successfully installed, see “Replication Agent”.

Sybase ASE Active Messaging

To verify that Sybase ASE Active Messaging has been installed successfully:

Make sure you have the message bus software, such as IBM WebSphere MQ, TIBCO EMS, or EAServer JMS installed in your environment, and you have already:

For IBM WebSphere MQ, set the follwing environment variable:
- $MQCCSID, the CCSID value of the connected queue managers
- For IBM AIX, include $IBM_MQ/lib64 to LIBPATH
IBM_MQ is the installation directory for IBM WebSphere MQ.
For TIBCO EMS and EAServer JMS:
- If you are using ASE 12.5.4 ESD#6 or later, or ASE 15.0.2 GA, set the $SYBASE_JRE variable to point to $SYBASE/Shared/jre142, so that the JVM can start when you enable real-time messaging.
- If you are using ASE 15.0.2 ESD#1 or later, set the $SYBASE_JRE_RTDS variable to point to $SYBASE/Shared/jre142, so that the JVM can start when you enable real-time messaging.

Make sure the ASE Active Messaging subcomponent has been installed successfully:

For IBM WebSphere MQ, go to the $SYBASE/ASE-15_0/lib directory and check if the libsybibmmq.so file exists.
For TIBCO EMS and EAServer JMS, go to the $SYBASE/ASE-15_0/lib directory and check if the following files exist.
- jrtms.jar
- libshmemrtds.so

Make sure Adaptive Server is up and running.

Go to the $SYBASE/ASE-15_0/scripts directory. Using isql, enter:

isql -Usa -P –Sserver_name -i installmaster

isql -Usa -P -Sserver_name -i installmsgsvss

isql -Usa -P -Sserver_name -i instmsgs.ebf

The instmstr and installmaster scripts return system procedures to their original version, installmsgsvss script installs system stored procedures for real-time messaging services, and instmsgs.ebf script brings your Adaptive Server messages up to the correct level.

If you have installed the ASE Active Messaging subcomponent on top of ASE 12.5.4 ESD#3, go to the $SYBASE/ASE-12_5/scripts directory using a command line. Using isql, enter the following for IBM WebSphere MQ and TIBCO EMS:

isql -Usa -P -Sserver_name -i installmsgsvss

Restart ASE.

Go to the $SYBASE directory. Using isql, enter:

isql –Sserver_name –Usa -P

To configure the server to use real-time messaging, enter:

For IBM WebSphere MQ:

1>sp_configure "enable real time messaging", 1, "ibm_mq"

2>go

For TIBCO EMS:

1>sp_configure "enable real time messaging", 1, "tibco_jms"

2>go

For EAServer JMS:

1>sp_configure "enable real time messaging", 1, "eas_jms"

2>go

Check the return status value to verify if real-time messaging has been successfully enabled. A return status value of 0 means success.

ASE 12.5.4 ESD #6 does not support EAServer JMS.