6.8.2 Deleting session information storage table and blank record information table
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.
-
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
-
-
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.
-
-
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.