In
a shared-disk cluster, each instance must have a local
system temporary database.
In the Cluster Edition, if an instance does not have a local system
temporary database, it starts only if it is the first instance in the cluster to
start.
If you are not using the master device for the temporary
databases, create the devices for the local system temporary databases.
You can create local system temporary database on shared disks only.
See Using Temporary Databases in the Cluster Users Guide.
Sybase recommends that you use separate devices for log and data for these
databases. For example:
disk init name="tempdbdev1",
physname="/dev/raw/raw14",
size="400M"
And for the log device:
disk init name="temp_log_dev1",
physname="/dev/raw/raw15",
size="200M"
Create a local system temporary database for each instance
in the cluster. For example, to create three local system temporary
databases "ase1_tdb1," "ase2_tdb1," and "ase3_tdb1" for
instances "ase1," "ase2," and "ase3," respectively,
enter:
create system temporary database ase1_tdb1 for instance ase1 on tempdbdev1 = 100
log on temp_log_dev1 = 50
create system temporary database ase2_tdb1 for instance ase2 on tempdbdev1 = 100
log on temp_log_dev2 = 50
create system temporary database ase3_tdb1 for instance ase3 on tempdbdev1 = 100
log on temp_log_dev3 = 50
Shut down the cluster using the shutdown cluster command.