Tips and Tricks to Partition In-Memory Cubes for Faster Performance

SYMPTOM
When attempting to start the Strategy 10.0 GA Enterprise Manager service on the AIX or Solaris operating systems, the following (or similar) error is displayed:

Failed to open </home/mstr/Strategy/install/_jre/jre/lib/ppc64//libjvm.so> - reason:<Could not load module /home/mstr/Strategy/install/_jre/jre/lib/ppc64//libjvm.so.
System error: No such file or directory>
Internal Error: Failed to initialize redirector – exiting
MSTRExec: abnormal exit!

 
STEPS TO REPRODUCE

1. Create a DSN for the Enterprise Manager warehouse.
2. Configure the Enterprise Manager warehouse.
3. Configure the DSN for Enterprise Manager in the Strategy Service Manager. Test the connection, it should succeed.
4. When attempting to start the Enterprise Manager service in Strategy Service Manager, the following error will be seen:

Failed to open </home/mstr/Strategy/install/_jre/jre/lib/ppc64//libjvm.so> - reason:<Could not load module /home/mstr/Strategy/install/_jre/jre/lib/ppc64//libjvm.so.
System error: No such file or directory>
Internal Error: Failed to initialize redirector – exiting
MSTRExec: abnormal exit!

CAUSE
This behavior is the result of a known defect in Strategy Enterprise Manager 10.0 GA and has been resolved in Strategy 10.0 Hotfix 1 and higher versions.
 
ACTION
Apply Strategy 10.0 Hotfix 1 to take advantage of the fix.
 
WORKAROUND
Change the shell script for starting the service as given below:
AIX:
In the file "mstrexec-emservice" located in the bin directory, for example:

/<MSTR_HOME>/bin/mstrexec-emservice.10.0.2500.0134

 
Add the line in bold below:

#! /bin/ksh
#
# This is the startup script for
# Strategy EM Service
#
# Copyright (c) 2003-2004 Strategy Incorporated
# 
. "$(dirname "$0")"/../env/Principal.sh
. "${MSTR_HOME_PATH:?}"/env/BinaryPaths.sh
. "${MSTR_HOME_PATH:?}"/env/Registry.sh
. "${MSTR_HOME_PATH:?}"/env/JVM.sh
. "${MSTR_HOME_PATH:?}"/env/ODBC.sh
 
export MSTR_JAVA_VMS_LIB="${JAVA_HOME:?}"/lib/ppc64
export Strategy_JAVA_VM_PATH=”${JAVA_HOME:?}”/lib/ppc64/j9vm/libjvm.so
 
mstr_prepend_path LIBPATH ${MSTR_JAVA_VMS_LIB:?}/j9vm
mstr_prepend_path LIBPATH ${MSTR_JAVA_VMS_LIB:?}
 
#preload this libraries
export LDR_PRELOAD64=libjvm.so:${LDR_PRELOAD64}
export LDR_PRELOAD64=libjava.so:${LDR_PRELOAD64}
export LDR_PRELOAD64=libmlib_image.so:${LDR_PRELOAD64}
 
exec "${MSTR_INSTALL_PATH:?}"/bin/MSTRExec "$@" –noconsole

 
Solaris:
In the file "mstrexec-emservice" located in the bin directory, for example:

/<MSTR_HOME>/bin/mstrexec-emservice.10.0.2500.0134

 
Add the lines in bold below:

#! /bin/ksh
#
# This is the startup script for
# Strategy EM Service
#
# Copyright (c) 2003-2004 Strategy Incorporated
# 
. "$(dirname "$0")"/../env/Principal.sh
. "${MSTR_HOME_PATH:?}"/env/BinaryPaths.sh
. "${MSTR_HOME_PATH:?}"/env/Registry.sh
. "${MSTR_HOME_PATH:?}"/env/JVM.sh
. "${MSTR_HOME_PATH:?}"/env/ODBC.sh
 
export MSTR_JAVA_VMS_LIB="${JAVA_HOME:?}"/lib/sparcv9
export Strategy_JAVA_VM_PATH="${JAVA_HOME:?}"/lib/sparcv9/server/libjvm.so

mstr_prepend_path LIBPATH ${MSTR_JAVA_VMS_LIB:?}/server
mstr_prepend_path LIBPATH ${MSTR_JAVA_VMS_LIB:?}

#preload this libraries
export LDR_PRELOAD64=libjvm.so:${LDR_PRELOAD64}
export LDR_PRELOAD64=libjava.so:${LDR_PRELOAD64}
export LDR_PRELOAD64=libmlib_image.so:${LDR_PRELOAD64}
 
exec "${MSTR_INSTALL_PATH:?}"/bin/MSTRExec "$@" –noconsole

   
The Strategy Internal Reference Number for the issue discussed in this technical note is DE14643.