Avaya Business Communications Manager - PeriRDB Manual de usuario descargar pdf (Pagina 38)

PeriRDB User’s Guide

Page 38

Accelerating RDBMS Access With SQLClnt

You can accelerate RDBMS requests by coding the application to use a dedicated SQL

client (sqlclnt). Refer to page 13 for valid database configurations.

Using an SQL client can reduce traffic directed to an RDBMS server because each

SQL client can maintain an open connection to the RDBMS server. Applications can

use an SQL client connection and then release the SQL client for another application.

Installing PeriRDB installs SQLClnt.

For more information, see the Installing MPS Software on a Solaris Platform or

Installing MPS Software on an NT Platform book.

Limitations For SQLClnt

Executing a Resume connector following receipt of an SQL exception/condition

(sqlerr, etc.) in an attempt to resume execution at the SQL block for which the

condition occurred produces unpredictable results. For additional information about

the Resume connector, see the PeriProducer User Guide.

SQLClnt is not currently supported on Windows NT.

Configuring For SQLClnt

Before an application can use an SQLClnt, both the periq and the sqlclnt

daemons must be running.

Start the periq daemon before the sqlclnt daemon.

Typically, systems use configuration files to start required instances of these daemons.

See the periq and sqlclnt man pages for a description of the available command

line options. The most commonly used options are used as examples in this document.

Using the SQL Request Accelerator

To use an SQLClnt for an RDBMS request, select Use or Use and Release in the

SQL block window. If Use is specified, an sqlclnt is reserved for the current

application (after first being acquired, if necessary) and released only when a Use

and Release is subsequently specified in an SQL block (the release is automatic if

the application restarts or aborts). If Use and Release is specified, the sqlclnt is

released (for use by other applications) after the SQL block has executed.

After an SQL block specifies Use, every SQL block that needs to utilize the

"reserved" sqlclnt, must also specify the Use (or Use and Release) option.

Under Queue, enter a queue name (optional) to associate this SQL block with a

specific SQLClnt.

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 38