ColumnwiseMRI IBM data server driver configuration keyword

Specifies whether array input chaining is converted to column-wise array input for Db2® for z/OS® servers.

Equivalent CLI keyword

ColumnwiseMRI

Equivalent IBM® data server provider for .NET connection string keyword

N/A

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="ColumnwiseMRI" value="ON | OFF"/>

Default setting:

Conversion from array input chaining into column-wise array input is disabled.

Equivalent connection attribute:

SQL_ATTR_COLUMNWISE_MRI

Usage notes:

The multi-row insert (MRI) feature in Db2 for z/OS servers require data to be in a column-wise array form for multi-row INSERT and MERGE operations. The conversion from array input chaining into column-wise array input optimizes performance in applications that use the array input chaining feature because the data is sent in a compact form. The following example shows how to enable the conversion:

<databases>
  <database name="db-name" host="server-name" port="port-number">
   <parameter name="ColumnwiseMRI" value="ON"/>
  </database>
</databases>

The conversion does not take place in certain cases. See SQL_ATTR_COLUMNWISE_MRI for details.

The ColumnwiseMRI keyword has no effect unless you are connected to a Db2 for z/OS server.