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:
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.


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.
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)