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 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 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 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:
- Go to
Argus Console > System Configuration > Database
. - From the Database Server OS Timezone drop-down list, select a time zone.
- 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;
----
Parent topic: Configuring System Management - Common Profile Switches