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 also
can 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 you process 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 select only an even number of maximum database connections.
MBCS Roundtrip Processing
Options for handling characters
that might 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 might not
be converted correctly into Unicode. When these characters are converted
from Unicode back to multi-byte (a round trip), the original character
might 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 might cause an incorrect round-trip conversion.
- Ignore all round trip Failures
- Continue processing when a multi-byte character
is encountered that might cause an incorrect round-trip conversion.
This option is the default value.
- 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 might cause an incorrect round-trip conversion.
- Ignore all round trip Failures
- Continue processing when a multi-byte character
is encountered that might cause an incorrect round-trip conversion.
This option is the default value.
Select the Ignore all round
trip Failures option if the database does not contain
data with characters that might cause round-trip errors. You also
might select this option if the columns used to manipulate data in
a Column Map and the columns for which selection criteria are defined
do not contain characters that might cause round-trip errors.
Cascade Delete Rule
- Warn On Cascade Delete/Update
- Display
a warning if a cascading delete or update might 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
you are saving the Access Definition.
- Always
- Display a cascade delete/update warning at run time
of a process and when you are saving the Access Definition.
- Never
- Do not display a cascade delete/update warning.
This option 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 that is specified for Warn
on Cascade Delete/Update in Product Options is displayed
and cannot be modified. For more information, see 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 is 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 also
must be in unchained mode.
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. For more information, see the Installation and
Configuration Guide.