Chapter 3. Setting Up SQL Remote
Command-line installation of the stable queue
Thestable queue is a pair of database tables that hold transactions until they
areno longer needed by the replication system. EveryAdaptive Server
Enterprisedatabase participating in a SQL Remote installation needs a
stablequeue.
☞Fordetailed information about the stable queue, see “The stable queue”
onpage 265.
Thestable queue can exist in the same database as the database taking part
inSQL Remote, or in a separate database. Keepingthe stable queue in a
separatedatabase complicates the backup and recovery plan, but can
improveperformance by putting the stable queue workload on separate
devicesand/or a separate Adaptive Server Enterprise server.
❖Toinstall the stable queue
1. Locate the stable queue initialization script
stableq.sql
inyour
SQLRemote installation directory.
2. Make a backup copy of the
stableq.sql
scriptfile. Thenadd the following
twolines to the beginning of
stableq.sql
:
use database_name
go
where
database_name
isthe name of the database that will hold the stable
queue.
Thesetwo lines set the current database to
database_name
,so that the
stablequeue is created in the
database_name
database. The stable queue
tablesare owned by the database owner.
3. Run the script against your Adaptive Server Enterprise server.
Changeto the directory holding the stable queue script, and enter the
followingcommand line (which should be entered all on one line) to run
thescript:
isql -S server-name -U login_id -P password -I stableq.sql -
o logfile
where

server-name

isthe name of the Adaptive Server Enterprise,

login_id

and

password

correspondto a user with system administrator
permissionson the server who owns the database, and

logfile

isthe name
ofa log file to hold the log information from the script.
23