Installation guide

1> sp_create_syscoordinations
2> go
Adaptive Server uses this database for tracking transactions and during recovery. It is also
used by applications using two-phase commit and DTM.
4.
Verify that the sybsystemdb database is large enough. For an upgrade, the default size
for sybsystemdb is 124MB, or enough free space to accommodate the existing
sybsystemdb database, and the largest catalog that is to be upgraded, plus 10 percent
for logging upgrade changes. You may need more space if you are adding user-defined
stored procedures.
5.
If you use Java in the database, the preupgrade utility detects that you set sp_configure
"enable java" to 1, and requests that you enable PCI and configure sybpcidb before you
upgrade the server.
6.
Increase the default database size:
a) Use alter database to increase the size of the master database.
For example:
1> alter database tempdb on master=x
2> go
1> alter database model on master=x
2> go
where
x is the megabytes of space you are adding.
Repeat this process for each temporary and model databases making sure that model
is at no point larger than tempdb.
b) Use sp_helpdb to verify the size of each system database you increase in size.
c) Use sp_configure to update the values as indicated by the preupgrade utility.
This example updates the number of locks available for all users on Adaptive Server to
6,000:
sp_configure "number of locks", 6000
The sybprocsdev device
Sybase system procedures are stored in the sybsystemprocs database, which is stored in
the sysprocsdev device. You may need to increase the size of sysprocsdev before upgrading
Adaptive Server.
The minimum/default sybsystemprocs size is 172MB for all page sizes when
configuring a new server. For upgrades, you need an additional 10 percent of this.
You may need more space if you are adding user-defined stored procedures.
If your sybsystemprocs database does not meet these requirements and you have enough
room on the device to expand the database to the required size, use the alter database
command to increase the database size.
Use sp_helpdb to determine the size of the sybsystemprocs database:
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 79