Configure Database -- Fields and controls

Environment page

Performance page

Applications page

Logs page

Recovery page

Status page

Database partition

OK

Defaults

Cancel

Environment page

Parameters

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Performance page

Parameters

Parameter s

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Parameter filters

Beside the Parameters area there are radio buttons that allow you to display a subset of all the possible configuration parameters. For the Performance notebook page, you will see the following radio buttons:

All

Select this radio button to display all the configuration parameters for this notebook page.

Shared memory

Select this radio button to display only the configuration parameters related to shared memory.

Agent memory

Select this radio button to display only the configuration parameters related to agent memory.

Input/Output

Select this radio button to display only the configuration parameters related to input/output.

Storage

Select this radio button to display only the configuration parameters related to storage.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Applications page

Parameters

Parameter filters

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Parameter filters

Beside the Parameters area there are radio buttons that allow you to display a subset of all the possible configuration parameters. For the Applications notebook page, you will see the following radio buttons:

All

Select this radio button to display all the configuration parameters for this notebook page.

Applications

Select this radio button to display all the configuration parameters related to applications.

Locks

Select this radio button to display all the configuration parameters related to locks.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Logs page

Parameters

Parameter filters

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Parameter filters

Beside the Parameters area there are radio buttons that allow you to display a subset of all the possible configuration parameters. For the Logs notebook page, you will see the following radio buttons:

All

Select this radio button to display all the configuration parameters for this notebook page.

Log files

Select this radio button to display all the configuration parameters related to log files.

Log activity

Select this radio button to display all the configuration parameters related to log activity.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Recovery page

Parameters

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Status page

Parameters

Parameter filters

Value

Hint

Custom columns

Find

OK

Defaults

Cancel

Parameters

This area of the notebook page lists all the valid configuration parameters and their current values:

• The Parameter column shows the full name of the configuration parameter.
• The Value column shows the current value of the parameter.
• The Changed column displays an X beside a parameter if its value has been changed.
• The DB2 Parameter column shows the name that DB2 uses for the parameter.

Parameter filters

Beside the Parameters area there are radio buttons that allow you to display a subset of all the possible configuration parameters. For the Status notebook page, you will see the following radio buttons:

All

Select this radio button to display all the configuration parameters for this notebook page.

State

Select this radio button to display all the configuration parameters related to state.

Statistics

Select this radio button to display all the configuration parameters related to statistics.

Value

Use the fields and controls in the Value box to change the value of the selected configuration parameter by selecting the appropriate check box or radio button, and entering a value in the entry field as appropriate.

If you see beside a field, you can click to search for and select available files or directories for the field.

Changed values are not committed until OK is selected.

Click on Reset to restore the value that the selected parameter had when the notebook first opened.

Click on Default to show the default value for the selected parameter.

Hint

The Hint field changes according to the parameter that is selected in the Parameters area. It gives a brief description of what the configuration parameter is used for.

Custom columns

Select the type and order of the columns of information in the notebook, and reorder, include, or exclude them.

Find

Find a configuration parameter on the current notebook page by searching for a string in the columns of the Parameters field.

Database partition

Click on the down arrow to reveal the list of possible database partitions for the selected multipartition database. Highlight the database partition you want to view the configuration information for.

The configuration parameters in the notebook are updated to show the values for the selected database partition, but any changes made to the configuration parameters will affect all the nodes listed in the Database partition box (not just the one that is currently displayed).