Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » SQL Remote administration


Management overview

This chapter describes general issues and principles for administering a running SQL Remote installation.

For system-specific details, see Administering SQL Remote.

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.

  • Configuring 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.

  • 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.