Changing configuration values in a running server

If, with advice from Sybase Technical Support, you want to change the default configuration values, you can use the sp_jreconfig and sp_pciconfig system stored procedures. See “When to change configuration values”. This section describes how to load the changed configuration values into memory in a running server.

When Adaptive Server starts, it automatically loads the JVM if the server has been configured for Java. The JVM is not initialized, however, until it receives the first Java request. This depends on how frequently Java is used. Changing configuration values before initialization is relatively simple. Changing configuration values after initialization, when the configuration information has been read into in-memory data structures, is more difficult.

You can update configuration information: