Back
Next
Done
Show SQL
Cancel
Back
Next
Done
Show SQL
Cancel
Database page
Database
Restore saved parameters
Database
Displays the system, instance, and name of the currently selected database. Click on the Select push button to select a different database.
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:
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.
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
Target memory
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
Optimize for workload type
Optimize for workload type
Categorize your database usage by selecting a workload type.
The database will be optimized for queries.
The transactions page is hidden.
The database parameters will be set to balance the performance of queries and transactions.
The transactions page is visible.
The database will be optimized for transactions.
The transactions page is visible.
Default Value
Mixed
Transactions page
Number of statements (transaction
type)
Transactions per minute
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.
Each transaction has 10 or more SQL statements in a single unit of work.
Each transaction has 1 to 9 SQL statements in a single unit of work.
Default Value
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
Database administration priority
Database administration priority
Select one of the following to define what is more important for your database:
Faster transactions and longer roll-forward time during recovery.
Database parameters will be set to balance transaction performance with time to recover.
Faster recovery and slightly slower transaction performance.
Default Value
Both
Populated page
Is the database populated with data?
Is the database populated with data?
Choose this option if there is any data in the database.
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
Average number of connected local
applications
Average number of connected remote
applications
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
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
Isolation level (Row locking)
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.
Many locks of long duration.
Few locks of long duration.
Many locks of short duration.
No locks.
Default Value
Repeatable read
Results page
Performance parameters
Apply these recommendations immediately
Save to Script Center
Script name
Script description
Performance parameters
This table has four columns, listing the configuration parameter, its current value, the recommended value, and the DB2 parameter.
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.
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.
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.
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.
