Daylight Worksheet - Creating a database ...SHOW HINTS

Creating a database means creating the empty files which are in the format required by the Daylight database servers. These files must then be loaded with data to be useful. When creating a database, the following must be specified: (1) a datatypes database, (2) primary hash table size, (3) cross-reference hash table size. Also, the path of the database directory must be known. This is normally referenced by $DY_THORDB.

• Creating a database with sthorman -
  1. Launch sthorman and select the databases menu. Create a "regular" database and specify a handy datatypes database (e.g., medchem98demo_datatypes).

  2. Test that the database exists and is healthy by using the thordbping command and verifying that no error is reported.

  ---

• Creating a database with thormake -
  1. thormake requires that all parameters are specified on the command line. Here is an example:

     thormake \
'$DY_THORDB/test' 100 400 \
-DATATYPES_DATABASE 'test_datatypes'


  2. Again test that the database exists and is healthy by using the thordbping command.

  ---

• Destroying a database with thordestroy -
  1. thordestroy is a client program which instructs the server to delete all files associated with the specified database.

     thordestroy '$DY_THORDB/test'


  2. Verify that the database has been destroyed by using the thordbping command. Also examine the database directory for files.