Upgrading Java in the Database

You must run installpcidb script if the Java in the database functionality is currently enabled. This script creates tables and stored procedures in the sybpcidb database.

1. Using isql, run the installpcidb script that is included with the release. Save the output to an operating system file.

   isql -Usa -P<sa_password> -S<server_name>
     -i$SYBASE/$SYBASE_ASE/scripts/installpcidb -o<output_file>

2. Enable the Java in the database functionality:

   1> sp_configure 'enable pci', 1
   2> go
   1> sp_configure 'enable java', 1
   2> go

   You may need to increase 'max memory' to enable these parameters. Restart the server for changes to take effect. You can configure the maximum size of the PCI Bridge memory pool through the 'pci memory size' configuration parameter. For more information, see Java in Adaptive Server Enterprise for 15.7.

• Enabling Java in the Database in a High Availability System
  You can use the Java in the database feature on a system that also uses high availability.