Managing Java in the Database During Installations and Upgrades

If you have enabled the Java in the database feature, create the sybpcidb database before installing or upgrading to Adaptive Server version 15.7 SP100.

1. Create the sybpcidb database. The sybpcidb database stores configuration information for the pluggable component interface (PCI) and all pluggable component adapter (PCA) components. This database is used by the installpcidb script. For example:

   1> disk init
   2> name = "sybpcidb_dev",
   3> physname = "${SYBASE}/data/sybpcidb_dev.dat",
   4> size = "24M"
   5> go
   1> create database sybpcidb on sybpcidb_dev = 24
   2> go

   The device and database sizes depend on the Adaptive Server page size:

   • 2K page size – 24MB
   • 4K page size – 48MB
   • 8K page size – 96MB
   • 16K page size – 192MB

   Run the installpcidb script only on the first node and not on any other nodes in the cluster. In addition, create only the PCI device on the first node. A single instance of the PCI configuration is shared between the nodes of a cluster.

2. Disable the Java in the database feature:

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

3. Reenable the feature after you have successfully installed or upgraded to Adaptive Server 15.7 SP100:

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