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