Avaya Business Communications Manager - PeriRDB Bedienungsanleitung PDF herunterladen (Seite 39)

SQLClnt

Page 39

The following is an example of how to start an SQLClnt:

sqlclnt -v 254 -s 230 -m oracle -q MYoracle -c

To use the previous SQLClnt, the queue name MYoracle would have to be entered

into the Queue field of the SQL block, and the RDBMS type oracle would have to

be selected in the RDBMS field of the SQL block.

When using an SQLClnt (selecting Use or Use and Release) the Connect:

buttons Logon and Logoff are disabled. The application does not log on or log off the

RDBMS server; SQLClnt performs all the necessary logons and logoffs.

SQLClnt stores the number of retrieved records found for a Select statement in the

SQL_Info.RdbmsMsg data card. Users can assign this number to a Number data card

using the To Number operator in a Compute Block.

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

See the MPS Command Reference Manual (P0602476) for a description of the

available command line options. The most commonly used options are used as

examples in this document.

Using the SQLClnt Backup Server (-s option)

If the primary database (contacted when you use the - u suffix) can not be reached

(due to network problems, database shutdown, and so on), then use the secondary

database by adding the -S suffix.

Once SQLClnt connects to the secondary database server, it does not revert back to the

primary database server unless SQLClnt is restarted or if the connection to the

Name the SQLClnt

Queue

Reserve an SQLClnt for

the application

Release the SQLClnt for

use by other applications

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

Keine Kommentare

Avaya Business Communications Manager - PeriRDB Bedienungsanleitung Seite 39