Co-Existence of SICS P&C and Life

Co-Existence of SICS P&C and Life

Sharing tables and data #

Please see the System Administrator Guide for details.

Installing a Combined P&C and Life Database #

In order to prepare the database to be used by both products, the following procedure MUST be followed:

  1. Install both SICS P&C and SICS Life on the same (or two different) PCs
  2. Create tables and base data from the SICS Life System Administration Utility (as described in this document)
  3. Start the SICS P&C System Administration Utility and execute the following:
    1. Update Security
    2. Update Reference Data
    3. Update EDI Base Data

Note that step 2 will create all tables for both the Life system and the P&C system. The step will, however, only load base data and security information for the Life application.

Steps 3.1 - 3.3 take care of adding the P&C specific Base data to the database.

After this installation, the database can be used for holding both SICS Life and SICS P&C data. Various mechanisms within the systems make sure that the separation - and the integration - between the systems are managed properly.

Setting the “Database Configuration” System Parameter #

Once the database is created, open System Parameters. Search for and select ‘Database’ to view current “Database Configuration” settings. Edit the settings and indicate a Combined P&C and Life database.

This parameter setting will have an influence on some database queries. When the parameter is set, the queries will get an additional WHERE-clause for distinguishing between data that belongs to P&C and data that belongs to Life.

If the parameter is not correctly set, system errors may occur when retrieving data from the database.

install_15.png

Figure 15 - Global Defaults