Use the options on the Database tab
to set preferences for handling multi-byte round trip conversion errors,
cascade deletes, and database connections. For Sybase ASE, you can
also specify whether to run in Unchained mode.
Parallel Processing
- Maximum Database Connections
- Specify the default number of concurrent database
connections for an Archive, Delete, or Extract Process. Increasing
database connections improves performance when processing large quantities
of data by allowing multiple threads to process rows in parallel.
To increase the maximum number
of connections, select an even number from 2 through the site maximum
as specified in Product Options.
Note: For performance reasons,
you can only select an even number of maximum database connections.
MBCS Roundtrip Processing
Options for handling characters
that could cause round trip conversion issues in a multi-byte Optim™ Directory or DB Alias. The
availability of these options is governed by the MBCS Roundtrip
Processing settings on the Product Options Database tab.
Optim uses the
Unicode character set in dialogs and to process data. In some multi-byte
character sets (such as Oracle JA16SJIS), multiple characters are
mapped to the same Unicode character and may not be converted correctly
into Unicode. When these characters are converted from Unicode back
to multi-byte (a round trip), the original character may not be returned.
- Archive/Extract Requests
- Select an option for handling round trip conversion
issues during Archive or Extract processing:
- Stop Processing
- Stop processing when a multi-byte character is encountered
that could cause an incorrect round trip conversion.
- Ignore all round trip Failures
- Continue processing when a multi-byte character
is encountered that could cause an incorrect round trip conversion.
(Default.)
- Insert/Load/Convert Requests
- Select an option for handling round trip conversion
issues during Insert, Load, or Convert processing:
- Stop Processing
- Stop processing when a multi-byte character is encountered
that could cause an incorrect round trip conversion.
- Ignore all round trip Failures
- Continue processing when a multi-byte character
is encountered that could cause an incorrect round trip conversion.
(Default.)
Select the Ignore all round
trip Failures option if the database does not contain
data with characters that could cause round trip errors or if columns
used to manipulate data in a Column Map (e.g., a function is used)
and columns for which selection criteria are defined do not contain
characters that could cause round trip errors.
Cascade Delete Rule
- Warn On Cascade Delete/Update
- Display
a warning if a cascading delete or update may occur to a table that
is not explicitly included in an Access Definition or a process.
- Runtime
- Display a cascade delete/update warning only at
run time of a process.
- Saving Access Definition
- Display a cascade delete/update warning only when
saving the Access Definition.
- Always
- Display a cascade delete/update warning at run time
of a process and when saving the Access Definition.
- Never
- Do not display a cascade delete/update warning.
This is the default setting.
The Warn on Cascade Delete/Update setting
in Product Options affects the availability of this option for user
input. If available, you can click the down arrow to choose when to
display a warning. If unavailable, the value specified for Warn
on Cascade Delete/Update in Product Options is displayed
and cannot be modified. (Refer to the Installation and Configuration
Guide .)
Sybase Unchained Mode
- Run in Unchained Mode
- Optim normally
runs in chained mode. When a trigger in a Sybase ASE table will be
fired as a result of an Insert or Delete Process, and the trigger
calls a stored procedure that must run in unchained mode, the connection
must be in unchained mode for the procedure to work.
The Sybase
Unchained Mode setting in Product Options enables or disables
this check box. If enabled, select the check box to run Insert and
Delete Processes in Unchained Mode, or clear the check box to run
all actions in normal mode. (See the Installation and Configuration
Guide .)