Kbase P119099: SQL-92 connections hang on HP-UX 32-bit and the _sqlsrv2 process uses maximum CPU
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2011 |
|
Status: Verified
SYMPTOM(s):
_sqlsrv2 process uses maximum CPU
SQL-92 connections hang, for both ODBC and JDBC clients
When running ldd $DLC/bin/_sqlsrv2, the libjvm.sl cannot be found
4GL connections also hang after SQL-92 clients start to hang
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
HP-UX 11.0
HP-UX 11i 32-bit
CAUSE:
Bug# OE00136112
CAUSE:
$DLC/jre/lib/PA_RISC/classic/libjvm.sl needed for _sqlsrv2 is not to be found
FIX:
Edit $DLC/bin/java_env and modify, in the section "HP-UX", the variable VMTYPE so it is valued to "server" and not to "classic".
The result will be like (extract of java_env):
"HP-UX") # HP UNIX 11.00, No jdk but jre
THREADS_FLAG=native_threads
JDKHOME=/installdir/dlc/jre
if [ ! -f $JDKHOME/bin/javac ]
then
JDKHOME=$env_jdkhome
fi
VMTYPE=server
ARCH=PA_RISC
# set the shared library search path - snippet from the java script
SHLIB_PATH=$SHLIB_PATH:$JREHOME/lib/$ARCH/$THREADS_FLAG:$JREHOME/lib/$ARCH/$VMTYPE:$JREHOME/lib/$ARCH
export SHLIB_PATH
;;