Adaptive Server 15.0 uses larger databases because it uses row-locked system catalogs and adds several new system catalogs.
The new minimum sizes are:
Minimum database size – 6 allocation units (1536 pages, 3MB on a 2K page)
Minimum master database – 26 allocation units (6656 pages, 13MB on a 2k page)
Minimum tempdb size – the larger of 4MB or 6 AU
Minimum sybsystemprocs size – 124MB (132MB recommended)
The default database size configuration parameter default value has changed:
2K pages – 3MB
4K – 6MB
8K – 12MB
16K – 24MB
Make sure the database you are upgrading has plenty of free space. Although the preupgrade utility calculates the space necessary for catalog changes, be generous with the amount of available space in a database when performing an upgrade. Try to have at least 25% of the space free for databases less than 10GB. Also make sure the transaction log is as clear as possible. Truncate the transaction log after performing a full database dump, because the catalog changes also require log space.
Before upgrading, make sure the master database is using only about 50% of the available disk space and that sybsystemprocs has sufficient disk space for new stored procedures. Make a dump of the master database and dump the transaction log to truncate it, which is often the cause of space consumption in the master database.
Utilities like DBExpert, use abstract query plans, which are captured in the system segment. Make sure you have enough free space in the system segment beyond the catalog expansion requirements. Adaptive Server 15.0 adds the sysquerymetrics feature, which uses system segment space. Before you upgrade, prepare for sysquerymetrics by expanding the existing system segment to other devices if it was restricted to a smaller disk or a disk with little free space.
