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. The installpci script must only be run on 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. The sybpcidb database must be created 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 will work 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. Using isql, 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 following two configuration parameters in order to enable the Java in database functionality.

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

5. You may need to increase the 'max memory' in order to enable these parameters. After they are enabled, restart the server for changes to take affect. You can configure the maximum size of the PCI Bridge memory pool through the 'pci memory size' configuration parameter. For more information see the Java in Adaptive Server Enterprise for 15.5 guide.