Upgrading using sqlupgraderes

When you have finished editing your resource file, you can run the file using sqlupgraderes.

Notesqlupgraderes is a command line tool; therefore, unlike sqlupgrade, it does not require any X libraries.

Source the version 15.0.3 SYBASE.csh file before running sqlupgraderes and set OLDSYBASE and OLDSYBASE_ASE.

To execute sqlupgraderes, at the UNIX prompt, enter the following, where resource_file specifies the resource file containing the attributes that describe the server to upgrade:

$SYBASE/$SYBASE_ASE/bin/sqlupgraderes -r resource_file

Enabling PCI in Adaptive Server

To enable Java in database feature you must enable PCI and configure sybpcidb database. For sqlupgrade[res], the enable java setting in the old server is detected. If it is set at 1, then preupgrade asks you to create a sybpcidb device and database before you run upgrade.