Setting Up Local System and Temporary Databases

In a shared-disk cluster, each instance must have a local system temporary database.

1. Start Adaptive Server. For example:

   startserver -f $SYBASE/$SYBASE_ASE/install/RUN_ase1_coord

2. Log in to Adaptive Server.
3. 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.
   SAP 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"

4. 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

5. Shut down the cluster using the shutdown cluster command.