|
Use advanced options to modify the configuration
of both data
source and trace
files.
- Data source advanced options enable you to integrate the database connection and TSD
application better and to improve performance.
- Trace file advanced options control whether database tracing occurs, what is logged in
the database trace file, how it is formattted and how long the information is kept.
|
|
Use the Advanced Option Setup dialog box to
maintain the list of advanced options for either data sources or trace files. To access
this dialog box to configure advanced options for data sources:
- In the SQL Configuration
Editor dialog box, from the Sources list, select a data source and choose Configure.
- In the Source Setup dialog box,
choose Advanced.
Result: The Advanced Option Setup dialog box appears.
For more information, see the Tasks section of this
help topic.
To access this dialog box to configure advanced options for trace files:
- In the SQL Configuration
Editor dialog box, choose Trace Setup.
- In the Trace Setup dialog box, choose
Advanced.
Result: The Advanced Option Setup dialog box appears.
For more information, see the Tasks section of this
help topic.
|
|
Use the Option Selection dialog box to select an
advanced option for either data sources or trace files. To access the Option Selection
dialog box:
|
|
Use the Option Value Entry dialog box to
configure advanced options for either data sources or trace files. To access the Option
Value Entry dialog box:
Note: The appearance and content of the Option Value Entry dialog box
varies according to the requirements of the selected advanced option.
|
|
You can add advanced options for data sources
and trace files. To add an advanced option:
- In the Advanced Option Setup dialog box,
choose Add.
- In the Option Selection dialog box, select an
advanced option and choose Select.
- In the Option Value Entry dialog box, type
or select a value for the selected advanced option.
Note: The appearance and content of the Option Value Entry dialog box
varies according to the requirements of the selected advanced option.
- Choose OK.
Result: The advanced option and its value appears in the Advanced Option
Setup dialog box.
- Choose Exit to return to either the Source
Setup dialog box or the Trace Setup
dialog box, depending on where you started.
|
|
You can edit the values of the currently
configured advanced options for data sources and trace files. To edit an advanced
option:
- In the Advanced Option Setup dialog box,
select an option and choose Edit.
- In the Option Value Entry dialog box, type
or select a value for the selected advanced option.
Note: The appearance and content of the Option Value Entry dialog box
varies according to the requirements of the selected advanced option.
- Choose OK.
Result: The advanced option appears in the Advanced Option Setup dialog
box.
- Choose Exit to return to either the Source
Setup dialog box or the Trace Setup
dialog box, depending on where you started.
|
|
To delete an advanced option for a data source:
- In the Advanced Option Setup dialog box,
select an option from the Currently configured advanced options list and choose Delete.
Result: The selected option is removed from the Advanced Option Setup
dialog box.
|