Troubleshooting resource file installations

If you encounter problems during the build, configure, or upgrade of Adaptive Server using the srvbuild[res], sqlloc[res], or sqlupgrade[res], it may be that these utilities did not allow enough time for Adaptive Server to shut down properly.

You can set the environment variable SYBSHUTWAIT to force the utilities to wait for Adaptive Server to shutdown. For example:

% setenv SYBSHUTWAIT 120

This forces the utility to wait for 2 minutes to allow Adaptive Server to shut down before proceed with the next task.

If Adaptive Server or SQL Server fails the pre-upgrade test, sqlupgrade displays:

Server SERVER_NAME failed preupgrade eligibility test. See log for more information.
  1. From the Upgrade window, select Exit.

  2. Examine the log file created in the $SYBASE/$SYBASE_ASE/init/logs directory to find out why Adaptive Server or SQL Server failed the pre-upgrade eligibility test.

    If the log contains messages about insufficient space in sybsystemprocs, follow the instructions in “Increasing the size of the sybsystemprocs database” to correct the problem.

    After you resolve any problems, shut down Adaptive Server or SQL Server and use sqlupgrade to complete the upgrade session.