Configuring RTDS for Adaptive Server

Before you begin configuring RTDS, set your Adaptive Server environment settings by sourcing:

• On Unix – SYBASE.sh or SYBASE.csh

• On Windows – SYBASE.bat

In addition, if you are configuring Real-Time Data Services 4.5 to work specifically with Adaptive Server version 15.0.2 ESD #1 or later:

• JRE – set the SYBASE_JRE_RTDS environment variable so that it points to a valid JRE location.

• MQ – set the RTDS_MQCLIENT_VERSION environment variable as the current MQ client version. If the MQ client is:

  • Version 6.0 or later – set the varaible as 6.0

  • Version 5.3 – set the variable as 5.3.

Real-Time Data Services, as a messaging services feature, uses these Adaptive Server sp_configure configuration parameters, which you set when you configure Adaptive Server:

This example assumes that current 'max online engines' is 4.

-- Add 2 more to 'max online engines'.
sp_configure 'max online engines', 6
go
sp_configure 'max online Q engines', 2
go
sp_configure 'number of Q engines at startup, 2
go

1. Create and start a queue manager. In this example, the queue manager is called QM1:

   % crtmqm QM1
   

   WebSphere MQ queue manager created.
   Creating or replacing default objects for QM1.
   Default objects statistics : 31 created. 0 replaced. 
   0 failed.
   Completing setup.
   Setup completed.
   

   % strmqm QM1
   

   WebSphere MQ queue manager 'QM1' started.
   

2. Use the MQSC tool to create a queue. This example creates a queue called Q1 on the QM1 queue manager:

   % runmqsc QM1
   

   5724-B41 (C) Copyright IBM Corp. 1994, 2002. ALL RIGHTS RESERVED.
   Starting WebSphere MQ script Commands.
   define qlocal(Q1)
          1 : define qlocal(Q1)
   AMQ8006: WebSphere MQ queue created.
   end
          2 : end
   No MQSC commands read.
   No commands have a syntax error.
   All valid MQSC commands were processed.
   

3. Use the MQSC tool to define a server channel in the queue manager. This example defines a channel called CH1 on QM1:

   % runmqsc QM1
   

   5724-B41 (C) Copyright IBM Corp. 1994, 2002. ALL RIGHTS RESERVED.
   Starting WebSphere MQ script Commands.
   define channel(CH1) chltype(SVRCONN)
          1 : define channel(CH1) chltype(SVRCONN)
   AMQ8014: WebSphere MQ channel created.
   end
          2 : end
   No MQSC commands read.
   No commands have a syntax error.
   All valid MQSC commands were processed.
   

4. Add authorizations for the SYBASE user login and ASE logins. In this example, Adaptive Server runs as user “sybase,” the Adaptive Server messaging user is “login1”, and the queue is “Q1”:

   % setmqaut -m QM1 -t qmgr -p sybase +connect +altusr +inq +setid
   % setmqaut -m QM1 -t q -n Q1 -p login1 +inq +get +browse +put
   

5. Start an MQ listener. This example starts a listener on port 8765:

   % runmqlsr -t tcp -p 8765 -m QM1 &
   

The following shows the endpoint URL for the objects created in these examples, with “myhost” as the host name:

ibm_mq:CH1/tcp/myhost(8765)?qmgr=QM1,queue=Q1