With the database session failover functionality, you must create three types of tables in a database. The following table describes tables to be created and reference location of creation procedure.

Table 6-42 Tables to be created and reference locations of creation procedure

Table name	Physical name in the database	Reference location of creation procedure
Application information table	SFO_APPLICATION_ID_APP_INFO	6.8.3
Session information storage table	SFO_APPLICATION_ID_SESSIONS	6.8.4
Blank record information table	SFO_APPLICATION_ID_REC_INFO

Template files for creating database tables, which are used in the database session failover functionality, are stored in the following locations:

In Windows:

Application-Server-installation-directory\CC\sfo\sql\

In UNIX:

/opt/Cosminexus/CC/sfo/sql/

There are two types of template files for table creation for each database used. The following table describes mapping of databases to be used, files, and types of tables to be created.

Table 6-43 Template files for table creation and tables to be created

Database to be used	Template file	Types of table to be created
		Application information table	Session information storage table	Blank record information table
HiRDB	hirdb_create_apptbl.sql	Y	--
	hirdb_create_sessiontbl.sql	--	Y
Oracle	oracle_create_apptbl.sql	Y	--
	oracle_create_sessiontbl.sql	--	Y

Legend:

Y: Can be created

--: Cannot be created

The following subsections describe details on template files for each used database.

Register the creator of the table in the user set in DB Connector.