Process and Application code for configuring parameters in the DB2 Configuration Wizard

Today, we will focus on the actual operation process of using the DB2 Configuration Wizard to configure parameters. We will mainly introduce the actual operation process by implementing its operation code, DB2 version 8 provides a tool for automatic parameter configuration-Configuration Wizard. You can start the graphical interface configuration wizard in the control center or use the autoconfigure command to configure your database.

The Configuration Wizard allows you to configure the database controller, database configuration parameters, and buffer pool size.

DB2 version 8 provides a tool for automatic parameter configuration-Configuration Wizard. You can start the graphical interface configuration wizard in the control center or use the autoconfigure command to configure your database. The Configuration Wizard allows you to configure the database controller, database configuration parameters, and buffer pool size.

Note: You must connect to the database to use the Database Configuration Wizard. In the case of a partitioned database, the Database Configuration Wizard only configures one partition you connect. In a partitioned database environment, you can use the db2_all command to configure parameters for All Database partitions.

If you use the graphical interface's DB2 Configuration Wizard to configure parameters, you need to answer a series of questions, which are equivalent to the parameters in the AUTOCONFIGURE command (as shown in Table 1 ). First, let's take a look at the AUTOCONFIGURE Command Format:>-

 
 

  
  
AUTOCONFIGURE--+---------------------------------------+-----> 
  
  
| .----------------------------. |  
  
  
| V | |  
  
  
'-USING----input-keyword--param-value-+-'  
  
  
>--APPLY--+-DB ONLY----+--------------------------------------->< 
  
  
+-DB AND DBM-+  
 
 

'-NONE -------' table 1 shows the keyword and value range of the option. Table 1 default values of key words and value ranges

Mem_percent 1-100 80 sets the memory usage of DB2. For other applications, select a value smaller than 100.

 
 

  
  
workload_type simple, mixed, 
 
 

Complex mixed specifies the workload type. The simple type mainly refers to the concentrated IO access. For most OLTP systems, select the simple type. The Complex type mainly refers to Complex query systems that occupy a large amount of CPU, such as OLAP systems. If your system is between the two, select the mixed type.

Num_transaction TS 1-1 000 000 000 Number of SQL statements contained in each transaction in 10 Systems

Tpm 1-200 000 60 transactions per minute.

Admin_priority performance, recovery, both select your governance policy, which can be better performance or faster database recovery time.

Is_populated yes, no yes, the database already has data

Num_local_apps 0-5 000 0 local connections

Num_remote_apps 0-5 000 10 remote connections

Isolation level of isolation RR, RS, CS, ur rr applications

Bp_resizeable yes, no yes, whether the buffer pool can be adjusted

Apply db only displays the recommended database and buffer pool parameters under the DB2 Configuration Wizard configuration parameters of the current database controller, and applies the parameters to the database and buffer pool.

Apply db and dbm displays AND applies the recommended database controller parameters, database parameters, AND buffer pool parameters.

Apply none only displays the recommended values, but does not change the configuration parameters. The above content is an introduction to using the DB2 Configuration Wizard to configure parameters.