When changing the settings of an application that uses the database session failover functionality, deleting database tables might be required. This section describes deleting database tables.

The following table describes tables to be deleted and reference locations for the procedure of deleting.

Table 6-53 Tables to be deleted and reference location of the procedure of deleting

Table name	Physical name in a database	Reference location for the procedure of deleting
Application information table	SFO_APPLICATION_ID_APP_INFO	6.11.1
Session information storage table	SFO_APPLICATION_ID_SESSIONS	6.11.2
Blank record information table	SFO_APPLICATION_ID_REC_INFO

Template files for deleting database tables that are used in the database session failover functionality, are stored in the following location:

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 deletion for each database used. The following table describes mapping of databases to be used, files, and types of tables to be deleted.

Table 6-54 Template files for table deletion and tables to be deleted

Database to be used	Template file	Types of table to be deleted
		Application information table	Session information storage table	Blank record information table
HiRDB	hirdb_delete_apptbl.sql	Y	--	--
	hirdb_delete_sessiontbl.sql	--	Y	Y
Oracle	oracle_delete_apptbl.sql	Y	--	--
	oracle_delete_sessiontbl.sql	--	Y	Y

Legend:

Y: Can be deleted

--: Cannot be deleted

The following subsection describes details on template files for each database used.

Organization of this section

6.11.1 Deleting application information tables

6.11.2 Deleting session information storage table and blank record information table