Upgrading Java in the Database

The pluggable component interface (PCI) configuration values are used by all of the nodes in a cluster. To share files between nodes, using working directories, you need shared directory locations in the file system that are visible to all nodes using the same path.

1. Run the installpci script on only the first node, not on any other nodes in the cluster. A single instance of the PCI configuration is shared between the nodes of a cluster.
2. Create the sybpcidb database before running the installpcidb script. You can choose the location and size of this database. As long as the database is named sybpcidb the installpcidb script works correctly. For example:

   1> disk init
   2> name = "sybpcidb_dev",
   3> physname = "/dev/raw/raw20",
   4> size = '24MB'
   5> go
   1> create database sybpcidb on sybpcidb_dev = 24
   2> go

3. Once the sybpcidb database has been created, run the installpcidb script to create and populate the tables that hold the PCI and pluggable component adapter (PCA) configuration properties. Stored procedures and tables are created in the sybpcidb database. Use isql to run the installpcidb script that is included with the release. Save the output to an operating system file. For example:

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

4. 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.

• 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.