Perform the following tasks to check if the Sybase Real-Time Events components have been successfully installed.
To verify if RepConnector is installed successfully for your application server:
EAServer – go to %SYBASE%\EAServer and check if the repra directory exists.
BEA Weblogic – go to the Weblogic_installation_directory and check if the repra directory exists.
To verify if the Replication Server subcomponent has been successfully installed, see “Replication Server”.
To verify if the Replication Agent subcomponent has been successfully installed, see “Replication Agent”.
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 Sybase EAServer JMS installed in your environment, and you have already:
For IBM WebSphere MQ, set the environment variables:
%MQCCSID%, the CCSID value of the connected queue managers
Include %IBM_MQ%\bin to PATH, where IBM_MQ is the installation directory for IBM WebSphere MQ.
RTDS does not support IBM MQ on Windows 64-bit platform.
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\Sun\jre142_013, so that the JVM can start when you enable real-time messaging.
If you are using ASE 15.0.2 ESD#1 or later on Windows 32-bit platform, set the %SYBASE_JRE_RTDS% variable to point to %SYBASE%\Shared\Sun\jre142_013, 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\bin directory and check if sybibmmq.dll exists.
FOR TIBCO EMS and EAServer JMS, go to the %SYBASE%\ASE-15_0 directory and check if the following files exist:
jrtms.jar in the lib directory
shmemrtds.dll in the bin directory
Make sure Adaptive Server is up and running.
At the command prompt, go to the %SYBASE%\ASE-15_0\scripts directory. Using isql, enter:
isql -Usa -P –Sserver_name -i instmstr
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 prompt. 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 a command prompt. 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.