Application information table stores settings related to the database session failover functionality set in a Web application.

The procedures for creating the application information table are 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 of 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_apptbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/hirdb_create_apptbl.sql
     
   • Storage location of template files when using Oracle
     In Windows: Application-Server-installation-directory\CC\sfo\sql\oracle_create_apptbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/oracle_create_apptbl.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 in a template file.
   

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

   Change location		Change target	Change contents
   HiRDB	Oracle
   First line Fifth line	First line Fifth line	APPLICATION_ID	Change the application identifier of the application to be used.
   None	First line Fifth line	SCHEMA_NAME	Change the schema name of user connected to database.
   Sixth line	Sixth line	HTTP_SESSION_NO	Change the number 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.