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.

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 = '24MB'
   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

   Note: If you are upgrading from a pre 15.0.x server, do not disable Java in the database feature. sqlupgrade automatically disables this feature before an upgrade and re-enables the feature after an upgrade.
3. Reenable the feature after you have successfully installed or upgraded to Adaptive Server 15.7:

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