In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Connection Pool Manager Scripts
This script makes use of GNU sed and GNU wget so that it works on most flavors of UNIX, including HP-UX and AIX. So before running this script, please install the GNU sed and GNU wget, which are freeware downloads available from http://ftp.gnu.org/gnu/. Once both sed are gnu are installed, copy the executables (sed and wget) from the directory you installed (default /usr/local/bin) to this scripts directory to make sure the GNU versions of the programs are running and not the native OS ones.
In addition to managing connection pools through Connection Pool Manager in the administrative UI, you can also use the connection pool manager script to start, stop, restart, and shut down connection pools, as well as query the connection pool status:
conn-control.sh -Operation [Pool][Type]
Where Pool is the connection pool name and Type is the connection pool type, which is mandatory when Pool is used.
 
Operation
Description
h
Print the script help
q
Query the connection pool status
r
Restart connection pools
s
Start connection pools
x
Stop connection pools
Example: Use the following command to stop the connection pool named QADQXO with type SIAPI:
./conn-control.sh -x QADQXO SIAPI