User's Manual

Running the Message Agent . . . . . . . . . . . . . . . . . . 223
Tuning Message Agent performance . . . . . . . . . . . . . . 228
Encoding and compressing messages . . . . . . . . . . . . . 235
The message tracking system . . . . . . . . . . . . . . . . . . 237
11 Administering SQL Remote for Adaptive Server Anywhere241
Running the Message Agent . . . . . . . . . . . . . . . . . . 242
Error reporting and handling . . . . . . . . . . . . . . . . . . . 245
Transaction log and backup management . . . . . . . . . . . 249
Using passthrough mode . . . . . . . . . . . . . . . . . . . . 260
12 Administering SQL Remote for Adaptive Server Enterprise263
How the Message Agent for Adaptive Server Enterprise works 264
Running the Message Agent . . . . . . . . . . . . . . . . . . 269
Error reporting and handling . . . . . . . . . . . . . . . . . . . 271
Adaptive Server Enterprise transaction log and backup man-
agement . . . . . . . . . . . . . . . . . . . . . . . . . . . 272
Making schema changes . . . . . . . . . . . . . . . . . . . . 275
Using passthrough mode . . . . . . . . . . . . . . . . . . . . 276
13 Using SQL Remote with Replication Server 277
When you need to use the SQL Remote Open Server . . . . 278
Architecture for Replication Server/SQL Remote installations 279
Setting up SQL Remote Open Server . . . . . . . . . . . . . 282
Configuring Replication Server . . . . . . . . . . . . . . . . . 285
Other issues . . . . . . . . . . . . . . . . . . . . . . . . . . . 287
IV Reference 289
14 Utilities and Options Reference 291
The Message Agent . . . . . . . . . . . . . . . . . . . . . . . 292
The Database Extraction utility . . . . . . . . . . . . . . . . . 302
The SQL Remote Open Server . . . . . . . . . . . . . . . . . 312
SQL Remote options . . . . . . . . . . . . . . . . . . . . . . . 315
SQL Remote event-hook procedures . . . . . . . . . . . . . . 320
15 System Objects for Adaptive Server Anywhere 325
SQL Remote system tables . . . . . . . . . . . . . . . . . . . 326
SQL Remote system views . . . . . . . . . . . . . . . . . . . 333
16 System Objects for Adaptive Server Enterprise 337
SQL Remote system tables . . . . . . . . . . . . . . . . . . . 338
SQL Remote system views . . . . . . . . . . . . . . . . . . . 346
v