Kbase 15698: Probuild Small ESQL Client and -SV option and -N PIPES
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Probuild Small ESQL Client and -SV option and -N PIPES
This kbase is designed to assist customers having problems with Small
ESQL Clients connecting to database servers. Large ESQL clients
can execute like any other database client, using many of the same
startup parameters to manage database access. Small clients however
require that you start an Open Interface Broker to communicate with a
database server. (Regardless of if the client is local or remote).
The process for doing this is as follows:
1. Probuild your small ESQL client.
2. Start database server indicating -H hostname -S dbservicename
3. Set environment variables for PROOIBRK:
PROOIBRK=$DLC/bin/_prooibrk;export PROIBRK
4. Start Open Interface Broker:
prooibrk dbname -SV -S oibservicename -H hostname
5. Start client using your small client as follows:
IF OIB IS ON WINDOWS (UNIX AND WIN CLIENTS)
executable -db dbname -SV -S oibservicename -H hostname -N tcp.
IF OIB IS ON UNIX:
executable -db dbname -S dbservicename -H hostname -SV -S
oibservicename -H hostname.
Note: The important issue to keep in mind is that servicename
and oibservicename need to be different.
It does not matter what platform you are starting the client
from as long as the OIB is on WinNT the only connect parameters
you need to specify is the -db -SV -S oibservicename -H and -N.
Additional information can be obtained in the Embedded SQL Guide and
Reference manual - Chapter 3.
NOTE: It has been observed in version 7.3D08 on IBM AIX 4.1.4 that
starting the broker with -N PIPES caused the cpu utilization to go to
85-90%. If you observe this behavoir, remove the -N startup parameter
Progress Software Technical Support Note # 15698