Session information storage table stores global session information. The blank record information table manages the unused records in the session information storage table. The session information storage table and blank record information table are concurrently created by executing one SQL file for table creation.

The procedures for creating the session information storage table and blank record information table is as follows:

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

   Table 6-45 Change locations and change contents in a template file

   Change location		Change target	Change contents
   HiRDB	Oracle
   First line 13th line 18th line 19th line 23rd line 48th line 50th line 57th line 60th line 74th line	First line 13th line 18th line 19th line 23rd line 49th line 51st line 58th line 61st line 74th line	APPLICATION_ID	Change the application identifier of the application to be used.
   None	First line 13th line 18th line 19th line 23rd line 49th line 51st line 58th line 60th line 74th line	SCHEMA_NAME	Change the schema name of user connected to database.
   Seventh line	None	ATTRIBUTE_DATA_SIZE_MAX	Change the maximum size (units: bytes) of HTTP session attribute information.
   74th line	74th line	HTTP_SESSION_NO	Change the amount of global session information stored in the database.

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