Setting up local system temporary databases

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 will boot only if it is the first instance to boot in the cluster.

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. Sybase recommends 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.

Because a local system temporary database is always in use if its instance is running, you cannot drop the local system temporary database while the instance is running. To drop a local system temporary database, shutdown the instance and drop the local system temporary database from another instance.

To drop the local system temporary database of the last instance:

• Use sp_tempdb_markdrop to first mark the database to be dropped.

• Shutdown this instance.

• Drop the temporary database from another instance when you restart the cluster.

For example, if mycluster_tbdb_1 is the last local system temporary database, mark it with this command:

sp_tempdb_markdrop mycluster_tdb_1