Installation manual

Installing SYBASE Software

F Section 3

Installin g and Upgrading ENVOX

Configuration Software on DEC VAX and DEC AXP Systems (Revision B — May 1998)

3.4 tempdb Considerations for Client-Server Systems

During the installation of client-server SYBASE, a database called

tempdb is created. This database holds temporary tables created when

ENVOX software is running.

For large ENVOX databases or for an ENVOX database which will be

used by many users at the same time, the database tempdb should b e

increased in size and directed to a logical device which you define. The

device should be separate from the master, but in the same directory.

TheENVOXadministrationformscanbeusedtocreatealogicaldevice

for tempdb. The default size of tempdb is 6 mbytes. Increasing it by three

or four times, if there is enough disk space, is re commended.

To increase the size of tempdb, use the following procedure:

Step 1: Log into the SYBASE account.

Step 2: Run isql with the user being sa. The password will be

database if you have just completed the SYBASE installation.

> isql/u=”sa”/p=”database”

Step 3: Type the following commands in the isql prompt:

> alter database tempdb on tempdevice=newsize

> go

This action increases tempdb on tempdevice (your device

name) by the newsize (your entered size ) in Mbytes.