General Tab

Use the General tab to establish default fetch and extract limits for Archive, Compare, Edit, and Extract Processes. You can also select the site default calendar, determine when to display a warning for a cascade delete, and enable auditing for Optim™ processes.

Use the General tab to set these options:

General tab of Product Options, described in the following text

Limits

Establish the maximum number of rows in a fetch set for browsing or editing data or by using Point and Shoot. You can also set the maximum number of rows for extracting or archiving data.

Maximum Fetch Rows
Specify the maximum number of rows (1 - 100000) retrieved from a table. This limit applies to rows that are fetched to browse or edit table data or for Point and Shoot. If you do not specify a value, the default is 1000.

A user can establish a lower Maximum Fetch Rows limit by selecting Personal from the Options menu and editing the Display tab.

Maximum Extract Rows
Specify the maximum number of rows (1 - 999999999999) that can be processed during a single Extract or Archive Process. If you do not specify a value, the default is 100000.

A Row Limit for an Archive or Extract Process cannot exceed this value.

Site Defaults

The site-specific, default Calendar used to schedule action requests or to age data in a Column Map.

Calendar
Select a site default Calendar. To select from a list of available calendars, click the down arrow. You can select a different calendar on a process request, as needed.

Cascade Delete Rule

Set options for performing a cascading delete or update on tables that are not explicitly included in an Access Definition or a process.

Warn on Cascade Delete/Update
Click the down arrow to choose when to display a warning if a cascading delete or update might occur.
User
Allow the user to determine when to display a warning. User is the default setting.

The corresponding Warn on Cascade Delete/Update setting in Personal Options is enabled. For more information about the Warn on Cascade Delete/Update setting, see Warn on Cascade.

Runtime
Display a cascade delete/update warning only at run time of a process.

The corresponding setting in Personal Options is unavailable and set to Runtime.

Saving Access Definition
Display a cascade delete/update warning only when saving the Access Definition.

The corresponding setting in Personal Options is unavailable and set to Saving Access Definition.

Always
Display a cascade delete/update warning at run time of a process, and when saving the Access Definition.

The corresponding setting in Personal Options is unavailable and set to Always.

Never
Do not display a cascade delete/update warning.

The corresponding setting in Personal Options is unavailable and set to Never.

Abort Scheduler or Command Line
Select this check box to abort the process when run from the Scheduler or the Command Line Interface, and the cascade delete/update affects at least one table that is not explicitly included in the process. (This check box is selected by default.)

Audit Facility

Activates auditing for Optim processes. You can enable auditing for specific Optim Directories. See Process Audit for additional details.
Enable Process/Utility Audit

To enable auditing, select the Enable Process/Utility Audit check box and click Audit Selection to display the Audit Facility dialog. To create audit records for processes for an Optim Directory, select the Directory name and set Audit Status to the type of auditing that you want to use. If your audit data is hosted by Optim, select Enabled for each of the processes that you want to audit for the directory. You must repeat this step for each Optim Directory for which you want to create audit records.

To disable auditing for an Optim Directory, select the Directory name from Optim Directory and set Audit Status to Inactive.

When you clear Enable Process/Utility Audit on the General tab in Product Options, all process auditing is disabled, regardless of any auditing specification at the Optim directory level.

The Audit Facility dialog contains two tabs: Actions and Utilities.

Audit Facility panel with Actions tab displayed, described in the following text
Audit Facility panel with Utilities tab displayed, described in the following text

The Audit Facility dialog has the following fields:
Optim Directory
Name of the Optim Directory for which you are enabling or disabling auditing. Use Audit Status to enable auditing for the selected Optim Directory.
Audit Status

Specify the type of auditing to use for the selected Optim Directory. You can collect audit data in the Optim Directory, in a Guardium system, or in both the Optim Directory and a Guardium system.

If you collect audit data in a Guardium system, click Advanced Settings to specify the host names or IP addresses of the Guardium systems that you use.

Advanced settings dialog, described in the following text
In the Advanced Settings dialog, you must specify a master collector system. You can also specify a backup collector system to use when the master collector system is unavailable. Audit data is sent to the backup collector system only when the master collector system is unavailable. You can enter either the host name or IP address of each system. After you specify a system to use, click the corresponding Ping button to ensure that the Guardium system is available and capable of collecting Optim audit data. If the Guardium system is unavailable, or if the Guardium system cannot collect Optim audit data, a connection unsuccessful message is returned. Each Guardium system controls its own audit collection and retention policies. The other settings on the Audit Facility panel do not apply to audit information that is collected by a Guardium system.

Default Retention Days
Number of days for audit records to be retained in the Optim Directory. Specify a value in the range 1 - 999,999,999,999. The default value is 2,555 days (seven years).
Audit Record Limit
Number of audit records maintained at any time in the Optim Directory. Select a value in the range 100 - 999,999,999,999. The default value is 100,000.
Record Limit Action
Action to be performed when the Audit Record Limit is exceeded in the Optim Directory. Select one of these options:
Continue Auditing
Continue to generate audit records. The oldest audit records are discarded to keep the number of audit records under the limit.
Stop Auditing
Do not generate audit records for processes until the number of audit records drops below the Audit Record Limit value.
Purge Records
Deletes all audit records for the selected Optim Directory.
Actions/Utilities

The Actions and Utilities tabs list the processes for which audit records can be generated in the Optim Directory. If you enable auditing for an Optim Directory, audit records are generated only for processes that are selected on these tabs for that Optim Directory.

You can enable auditing for the following actions:
  • Archive Request
  • Compare Request
  • Convert Request
  • Delete Request
  • Extract Request
  • Insert Request
  • Load Request
  • Report Request
  • Restore Request
  • Table Editor
You can enable auditing for the following utilities:
  • Browse
  • Create
  • Import
  • Export
  • Optim Data Manager (ODM)


Feedback