Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Preparing for Implementation on the DB2 Host > Configuring DB2 Connect > Tuning DB2 Connect by Increasing the I/O Block SizeThe 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 V8 can support up to 10MB cursor blocks. If you are using DB2 for z/OS V8, you can increase the value of the RQRIOBLK parameter to 65 KB and so improve performance. |
![]() |
![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |