SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Getting Started
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
2-7
JVM Startup Options for Each SPJ Caller
VALUES ('UDR_JAVA_OPTIONS',
'-Djava.class.path=/usr/myclasses -Xmx32M');
The UDR_JAVA_OPTIONS setting in the SYSTEM_DEFAULTS table overrides the
system-defined default setting, which is OFF. For more information, see the SQL/MX
Reference Manual.
Scope of JVM Startup Options in the SYSTEM_DEFAULTS
Table
A UDR_JAVA_OPTIONS setting in the SYSTEM_DEFAULTS table persists for all
processes (or sessions) that run on the same node as the SYSTEM_DEFAULTS table.
The insertion of the UDR_JAVA_OPTIONS setting into the SYSTEM_DEFAULTS table
does not affect the current process. You must end and restart the process for the
setting to take effect. In addition, the insertion does not affect previously compiled
modules of an SQL/MX application unless you recompile those modules.
Precedence of JVM Startup Options
A UDR_JAVA_OPTIONS setting in a CONTROL QUERY DEFAULT statement takes
precedence over the setting in the SYSTEM_DEFAULTS table. See JVM Startup
Options for Each SPJ Caller on page 2-7.
Displaying the UDR_JAVA_OPTIONS in Effect for a Node
To show the UDR_JAVA_OPTIONS setting in effect for the system, enter the
SHOWCONTROL ALL command in an MXCI session. For more information about
SHOWCONTROL, see the SQL/MX Reference Manual.
JVM Startup Options for Each SPJ Caller
To set JVM startup options for each caller of an SPJ, use a CONTROL QUERY
DEFAULT statement. A UDR_JAVA_OPTIONS setting in a CONTROL QUERY
DEFAULT statement takes precedence over the system-defined default setting, which
is OFF, and settings in the SYSTEM_DEFAULTS table.
For the effect of the UDR_JAVA_OPTIONS setting on different callers, see:

Scope of JVM Startup Options in an SPJ Method on page 2-8

Scope of JVM Startup Options in Statically Compiled Applications on page 2-8

Scope of JVM Startup Options in Dynamically Compiled Applications on page 2-8

Scope of JVM Startup Options in an MXCI Session on page 2-9
For information about the syntax of the CONTROL QUERY DEFAULT statement, see
the SQL/MX Reference Manual.