Configuring Database

This screen enables you to configure the case processing fields and items for the database. Select System Configuration > Database to view the Common Profile Configuration screen.

To view the list of field names associated with the Case Processing > Database section, click the Database folder in the left panel.

The field names associated with Modify Database appear in the right panel.

Field Descriptions

The following table lists the fields available under Modify Database:

Field or Control Name	Description
Database Server OS Timezone	The database server timezone can be specified here. This value can be configured during the Oracle Argus database installation. Note that the timezone selected here should be in sync with the database, web and transaction servers. For further information, see "GMT Offset Calculation" below.
Override Case Seriousness Calculation Function (Note: Default function shall be used if left BLANK)	If this configured in Common Profile Switches > Database > Modify Database, the configured function is executed. Note: Default function shall be used if left BLANK.
Override Case Listedness Calculation Function (Note: Default function shall be used if left BLANK)	If this configured in Common Profile Switches > Database > Modify Database, the configured function is executed. Note: Default function shall be used if left BLANK.
Override Case Causality Calculation Function (Note: Default function shall be used if left BLANK)	If this configured in Common Profile Switches > Database > Modify Database, the configured function is executed. Note: Default function shall be used if left BLANK.

GMT Offset Calculation

The system uses the time zone of the DB server to perform GMT calculations. This time zone is initially loaded during the Oracle Argus database installation.

To set up the time zone:

1. Go to Argus Console > System Configuration > Database.
2. From the Database Server OS Timezone drop-down list, select a time zone.
3. Alternatively, update the DATABASE_TIMEZONE key in the CMN_PROFILE table.

Make sure that Argus is using the gss_util.gmt_offset function to derive the GMT OFFSET which impacts the calculation of GMT date and time.

Assume that Daylight Saving Time starts on the first Sunday of April at 2:00 AM and ends on the last Sunday of October at 2:00 AM.

To find out the time zone offset for the time zone regions, execute the following query:

SELECT tzname, tz_offset(tzname) offset, tzabbrev FROM gv$timezone_names;
----