Implementing Siebel Business Applications on DB2 for z/OS > Preparing for Implementation on the DB2 Host > Configuring DB2 Connect >

Tuning DB2 Connect by Increasing the I/O Block Size

The RQRIOBLK database manager configuration parameter specifies the maximum size of the client I/O blocks used to store the results of queries sent by a database client to a remote database.

To ensure that database queries which return large blocks of data do not cause DB2 Connect users to experience long response times, you can change the value of the client RQRIOBLK database manager configuration parameter.

The default value for the RQRIOBLK parameter on DB2 Connect is 32 KB and the maximum size is 65 KB. DB2 for z/OS can support up to 10MB cursor blocks so you can increase the value of the RQRIOBLK parameter to 65 KB and so improve performance.

To change the DB2 Connect I/O block size (RQRIOBLK) value

• Using the Command Line Processor, change the RQRIOBLK size by typing the following:

  DB2 UPDATE DBM CFG USING RQRIOBLK 65535