Performance Configuration SmartGuide -- Fields and controls

Database page
Server page
Workload page
Transactions page
Priority page
Populated page
Connections page
Isolation page
Results page
Figure pbullet not displayed. Back
Figure pbullet not displayed. Next
Figure pbullet not displayed. Done
Figure pbullet not displayed. Show SQL
Figure pbullet not displayed. Cancel



Database page

Figure pbullet not displayed. Database
Figure pbullet not displayed. Restore saved parameters

Figure pbullet not displayed. Database

Displays the system, instance, and name of the currently selected database. Click on the Select push button to select a different database.

Figure pbullet not displayed. Restore saved parameters

These radio buttons are available if the SmartGuide saved your selections and the results from the previous time you ran the Performance Configuration SmartGuide with this database.

Select on of the following options:

Calculate new parameters.

Go through all the pages of the SmartGuide to recalculate new suggested configuration parameters.

Use this option if the amount of data in your database has increased or decreased, your server has more memory, or you want to change any of your selections on one of the pages of the SmartGuide.

Restore the parameters saved on: date time.

Go through just the first page (Database) and the last page (Results) of the SmartGuide to restore the saved configuration parameters.

Use this option if the last set of configuration parameters suggested by the Performance Configuration SmartGuide did not adequately improve your performance. The configuration parameters that were in effect before you applied the suggested parameters will be reapplied to your database.



Server page

Figure pbullet not displayed. Target memory

Figure pbullet not displayed. Target memory

Move the slider to select the amount of memory that you intend to devote to database processing. The available memory shows the amount of installed RAM detected on the server.

Default Value

100%



Workload page

Figure pbullet not displayed. Optimize for workload type

Figure pbullet not displayed. Optimize for workload type

Categorize your database usage by selecting a workload type.

Queries (data warehousing)

The database will be optimized for queries.

The transactions page is hidden.

Mixed

The database parameters will be set to balance the performance of queries and transactions.

The transactions page is visible.

Transactions (order entry)

The database will be optimized for transactions.

The transactions page is visible.

Default Value

Mixed



Transactions page

Figure pbullet not displayed. Number of statements (transaction type)
Figure pbullet not displayed. Transactions per minute

Figure pbullet not displayed. Number of statements (transaction type)

Select the type of transactions in your database. Note that long transactions tend to consume more resources for a longer period of time than do short transactions.

More than 10 (long transactions)

Each transaction has 10 or more SQL statements in a single unit of work.

Fewer than 10 (short transactions)

Each transaction has 1 to 9 SQL statements in a single unit of work.

Default Value

long transactions

Figure pbullet not displayed. Transactions per minute

Estimate the number of transactions per minute for your database.

Enter a number from 1 to 10000, or use the spin buttons to increase or decrease the displayed value.

You can use performance monitoring to get a better estimate for this value.

Default Value

60



Priority page

Figure pbullet not displayed. Database administration priority

Figure pbullet not displayed. Database administration priority

Select one of the following to define what is more important for your database:

Transaction performance (slower recovery)

Faster transactions and longer roll-forward time during recovery.

Both are equally important

Database parameters will be set to balance transaction performance with time to recover.

Time to recover database (slower transactions)

Faster recovery and slightly slower transaction performance.

Default Value

Both



Populated page

Figure pbullet not displayed. Is the database populated with data?

Figure pbullet not displayed. Is the database populated with data?

Yes

Choose this option if there is any data in the database.

No

Choose this option if this is a new database with empty tables.

Whenever the size of the database increases or decreases significantly, run this SmartGuide again. The new size of the database will be used to calculate a new set of recommended configuration parameters.

Default Value

Yes



Connections page

Figure pbullet not displayed. Average number of connected local applications
Figure pbullet not displayed. Average number of connected remote applications

Figure pbullet not displayed. Average number of connected local applications

Enter the average number of local applications connected to the database at any one time. Local applications run on the same machine as this database.

Use the spin buttons to increase or decrease the displayed value.

Default Value

0

Figure pbullet not displayed. Average number of connected remote applications

Enter the average number of remote applications connected to the database at any one time. Remote applications run on a different machine from this database.

Use the spin buttons to increase or decrease the displayed value.

Default Value

10



Isolation page

Figure pbullet not displayed. Isolation level (Row locking)

Figure pbullet not displayed. Isolation level (Row locking)

Indicate the isolation level of the connected applications. Isolation levels influence how row locking is used in the database. Isolation level is also known as concurrency level. If you are unsure, pick a higher level of isolation.

Repeatable read

Many locks of long duration.

Read stability

Few locks of long duration.

Cursor stability

Many locks of short duration.

Uncommitted read

No locks.

Default Value

Repeatable read



Results page

Figure pbullet not displayed. Performance parameters
Figure pbullet not displayed. Apply these recommendations immediately
Figure pbullet not displayed. Save to Script Center
Figure pbullet not displayed. Script name
Figure pbullet not displayed. Script description

Figure pbullet not displayed. Performance parameters

This table has four columns, listing the configuration parameter, its current value, the recommended value, and the DB2 parameter.

Figure pbullet not displayed. Apply these recommendations immediately

Select this check box if you want to apply the recommended values to the current database when the Done push button is clicked.

If you select this check box and click Done, the changes will not take effect until the next db2start command is issued.

You can select Done only after you have selected at least one of the check boxes on this page.

Figure pbullet not displayed. Save to Script Center

Select this check box if you want to save a script file that can apply the recommended values to the current database. Use the Script Center to run or schedule the script.

After you have run the script and you are ready for the new configuration parameters to take effect, stop the instance and then start the instance.

Rebind your packages, if necessary.

The file will be saved when you click the Done push button.

You can select Done only after you have selected at least one of the check boxes on this page.

Figure pbullet not displayed. Script name

Specifies the drive, path, and name of a file. You can either type the fully qualified name, or click Browse to open the browse file window.

This field is available only when Save to Script Center is selected.

Figure pbullet not displayed. Script description

Type a description of the script in this entry field.

This field is available only when Save to Script Center is selected.

The description will appear with the script in the Script Center.