User's Manual

Management overview

This chapter describes administration issues for SQL Remote installations.

Administration of a deployed and running SQL Remote setup is carried out

at a consolidated database.

♦ Permissions As a SQL Remote installation includes many different

physical databases, a consistent scheme for users having permissions on

remote and consolidated databases is necessary. A section of this chapter

describes the considerations you need to make when assigning users

permissions.

♦ Conﬁguring message systems Each message system that is used in a

SQL Remote installation has control parameters and other settings that

must be set up. These settings are discussed in this chapter.

♦ The Message Agent The Message Agent is responsible for sending and

receiving messages. While some details of how the Message Agent

operates and the conﬁguration options for it, are different for Adaptive

Server Anywhere and Adaptive Server Enterprise, some concepts and

methods are common to both. These common features are discussed here.

♦ Message tracking Administering a SQL Remote installation means

managing large numbers of messages being handed back and forth

among many databases. A section on the SQL Remote message tracking

system is included to help you understand what the messages contain,

when they are sent, how they are applied, and so on.

♦ Log management SQL Remote obtains the data to send from the

transaction log. Consequently, proper management of the transaction log,

and proper backup procedures, are essential for a smoothly running

SQL Remote installation. While many details depend on the server you

are running, the generic issues are discussed in this chapter.

♦ Passthrough mode This is a method for directly intervening at a

remote site from a consolidated database. This method is discussed in

this chapter.

200