Restoring default configuration values to sybpcidb

The steps for restoring the default configuration values to the sybpcidb configuration values after the JVM has been initialized depend on whether you can restart Adaptive Server, and whether you are using a single- or multiple-engine Adaptive Server.

If you are using a single-engine Adaptive Server:

1. Reinstall the installpcidb installation script to reset the sybpcidb configuration table values to their factory defaults. For example:

   isql -Usa -Psa_password -Sserver_name 
   -i $SYBASE_ASE/scripts/installpcidb
   

2. Restart Adaptive Server. The default configuration values take effect when the JVM initializes in response to the first Java request.

If you are using a multiple-engine Adaptive Server:

1. Reinstall installpcidb to reset the sybpcidb configuration table values to their factory defaults. For example:

   isql -Usa -Psa_password -Sserver_name 
   -i $SYBASE_ASE/scripts/installpcidb
   

2. Bring the engine running the JVM offline. For example:

   sp_engine "offline", 3
   

   In this example, the JVM is running on engine “3”.

3. Bring the engine running the JVM back online. For example:

   sp_engine "online", 3 
   

You do not need to restart Adaptive Server for the new configuration values to take effect.