Preparing the Database and Devices for the Upgrade

If you ran the preupgrade, it scanned the system catalogs and calculates how much additional space you need to perform the upgrade.

If you did not run preupgrade, manually calculate how much free space to add to the system catalogs and databases. As a general rule, double the size of the largest catalog you are upgrading, and add approximately 10 percent more space. If you have a large number of stored procedures or compiled object in any database, the syscomments and sysprocedures catalogs will require additional space.

Note: Sybase recommends that you use preupgrade to determine how much free space is required for the upgrade.

Create a sybsystemdb database All servers must have a sybsystemdb database. Adaptive Server uses this database for tracking transactions and during recovery. In addition, it is used for applications using two-phase commit and Distributed Transaction Management (DTM).
If the database has insufficient space for upgrade, increase the size with alter database. Use preupgrade to determine the database size. If you have a sybsystemdb and the database is large enough, you do not need to make any changes.
If you do not have a sybsystemdb, and will not be using two-phase commit, create a sybsystemdb with a minimum of 4MB. The size you need depends on your page size.
Verify that the sybsystemprocs database is large enough. For an upgrade, the recommended minimum size for sybsystemprocs is the larger of 140MB, or enough free space to accommodate the existing sybsystemprocs database, and the largest catalog that is to be upgraded, plus an additional 10 percent for logging upgrade changes. You may need more space if you are adding user-defined stored procedures. 140MB accommodates additional internal data structures, but does not account for the possibility of a larger number of user-defined system procedures.
sybprocsdev is the default name for this device. However, it is frequently referred to as the sybsystemprocs device 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.