You must run installpcidb script if the
Java in the database functionality is currently enabled. This script
creates tables and stored procedures in the sybpcidb database.
-
Using isql, run the installpcidb script that is included with the
release. Save the output of this step to an operating system file.
isql -Usa -P<sa_password> -S<server_name>
-i$SYBASE/$SYBASE_ASE/scripts/installpcidb -o<output_file>
-
Enable the following two configuration parameters
in order to 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 the 'max memory' in
order to enable these parameters. After they are enabled it is necessary
to 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 Java
in Adaptive Server Enterprise for 15.5.