The session information storage table stores global session information. The blank record information table manages the unused records in the session information storage table.

This subsection describes the procedures for deleting the session information storage table and blank record information table.

1. Copy the template file to any location.
   A template file is provided as an SQL file used for deleting a table. The storage locations of template file for each used database are:
   
   • Storage location of template files when using HiRDB
     In Windows: Application-Server-installation-directory\CC\sfo\sql\hirdb_delete_sessiontbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/hirdb_delete_sessiontbl.sql
     
   • Storage location of template files when using Oracle
     In Windows: Application-Server-installation-directory\CC\sfo\sql\oracle_delete_sessiontbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/oracle_delete_sessiontbl.sql
     
2. Edit the template file.
   Edit the template file in accordance with preference information of a Web application and create an SQL file used for deleting a table. The following table describes change locations and change contents in template files.
   

   Table 6-56 Change locations and change contents in template files

   Change location		Change target	Change contents
   HiRDB	Oracle
   First line Second line Third line Fourth line	First line Second line Third line Fourth line	APPLICATION_ID	Change the application identifier of the application to be used.
   None	First line Second line Third line Fourth line	SCHEMA_NAME	Change the schema name of user connected to the database.

3. Execute the SQL file created for table deletion.
   For executing the SQL file, use SQL Executer when using HiRDB and SQL*Plus when using Oracle.