Using DB2 Connect

DB2 Connect Enterprise Edition is used for communication between the application server and DB2 Distributed Data Facility (DDF). When OS/390 is used as the data server, IBM DB2 for OS/390 is the only database that is supported. Lawson recommends the following DB2 Connect parameter value:

Note: RQRIOBLK is set using the DB2 UPDATE DBM CFG command. For DDCS gateways, use <update dbm configuration using rqrioblk 32767>

  • RQRIOBLK=32767

    32767 is the default value for the RQRIOBLK parameter. This large blocksize may improve the performance of large requests without adversely affecting small requests, such as requests for a single row of data. Use 32767 only if it does not cause much paging; if 32767 does cause paging, reduce the value of the parameter.

Although IBM recommends the following parameter settings, the Lawson applications have these parameters bound in their program. Therefore, it is not necessary to have the parameters in your .ini file to run the applications.

  • DEFERREDPREPARE=1

    The default in DB2 Connect, version 6. This parameter collapses prepare and execute messages and provides a performance boost.

  • CURSORHOLD=0

    The default is CURSORHOLD=1. This parameter releases locks at a commit point. Use the DB2 Connect Configuration Assistant to set this parameter appropriately.

  • AUTOCOMMIT=0

    The default is AUTOCOMMIT=1, which issues a commit after every SQL call. Set this parameter should be set to 0 to remove overhead when a commit is performed.

Bind Options

When connecting to OS/390 using DB2 Connect, Lawson recommends adding the following bind option to the BIND statement:

generic "KEEPDYNAMIC YES"

Adding this bind option may improve performance.