
sqlclnt -v 3 -s 230 -N nodeA -u sa/peri@database -m odbc -q odbcq32
-P 16 -Q 5
This command specifies the system to start the sqlclnt service and connect it to vmst 3 on
Node A through port 230. Port 230 is one of many available to sqlclnt and is configured in
$ASEHOME/etc/services. The unencrypted connection string to the database is sa/
peri@database. Database mode is ODBC and sqlclnt is part of queue odbcq32. The sqlclnt
service communicates with periq through port 16 with a ping rate of 5 seconds.
The following table lists sqlclnt attributes and their descriptions:
Table 7: sqlclnt Attributes
Attribute Description
-v # vps number
-s port port number to use
-N host VMS host machine (default - local)
-P port PeriQ port (default - any)
-m queue_type 'oracle', 'sybase', 'odbc', 'db2' or 'mssql'
-q name associated queue name
-u [<usr>[/<passwd>]
[@<server><odbc dsn
%OEM>]]
RDBMS connect string. If connect string contains @ or /, use \
\ as escape character.
-U cryptstring Crypted RDBMS connect string
-l directory Enable SQL Timing, specify directory path to place log files
-S backup user/psswd@server backup/fail over server. If connect string
contains @ or /, use \\ as escape character
-B crypststring Crypted RDBMS connect string for backup/fail over server
-c AUTOCOMMIT Enable AUTOCOMMIT
-x Transaction Timeout Transaction Timeout for a database Query (ODBC)
-L Login TimeOut Login TimeOut (ODBC)
-T poll new server connection poll (default 20 seconds)
-R # number of re-cycle attempts (default forever)
-Q ping rate Set ping rate for retrying connection to vmst (default 60
seconds)
-X {s|n} debugging level
-r {dev|file} redirect output
-H help
Database Access Configuration
94 Avaya Business Communications Manager—IVR Upgrade Guide September 2010
Comentarios a estos manuales