DB2 Version 9.7 for Linux, UNIX, and Windows

Generating database configuration recommendations

The Configuration Advisor is automatically run when you create a database. You can also run the Configuration Advisor by specifying the AUTOCONFIGURE command in the command line processor (CLP) or by calling the db2AutoConfig API.

About this task

To request configuration recommendations using the CLP, enter the following command:

   AUTOCONFIGURE
        USING input_keyword param_value
        APPLY value

Following is an example of an AUTOCONFIGURE command that requests configuration recommendations based on input about how the database is used but specifies that the recommendations not be applied:

   
   DB2 AUTOCONFIGURE USING 
        MEM_PERCENT 60 
        WORKLOAD_TYPE MIXED 
        NUM_STMTS 500 
        ADMIN_PRIORITY BOTH 
        IS_POPULATED YES 
        NUM_LOCAL_APPS 0 
        NUM_REMOTE_APPS 20 
        ISOLATION RR 
        BP_RESIZEABLE YES 
   APPLY NONE

Generating database configuration recommendations

About this task

Before you begin