Array size option is not available in the tdb2input component.
Db2input component: -array size option is not available in the tdb2input component. for this Is there any option in the component to increase the row read per sec count in db2 input component?
Based on the official documentation: https://www.ibm.com/docs/en/db2/11.1?topic=pdsdjs-common-data-server-driver-jdbc-sqlj-properties-all-database-products
There are parameters that you can set up in the JDBC URL itself. (Additional JDBC Parameters of the Advanced Settings.)
Would you mind trying these parameters:
fetchSize
Specifies the default fetch size for ResultSet objects that are generated from Statement objects. The data type of this property is int.
The fetchSize default can be overridden by the Statement.setFetchSize method. The fetchSize property does not affect Statement objects that exist when fetchSize is set.
Possible values of fetchSize are: 0 or positive-integer
queryDataSize
Specifies a hint that is used to control the amount of query data, in bytes, that is returned from the data source on each fetch operation. This value can be used to optimize the application by controlling the number of trips to the data source that are required to retrieve data.
Use of a larger value for queryDataSize can result in less network traffic, which can result in better performance. For example, if the result set size is 50 KB, and the value of queryDataSize is 32767 (32 KB), two trips to the database server are required to retrieve the result set. However, if queryDataSize is set to 65535 (64 KB), only one trip to the data source is required to retrieve the result set.
Also based on other sources: https://storage.ning.com/topology/rest/1.0/file/get/2653155734?profile=original (Slide 36) it looks that you can't even try the per statement fetch size in a tJDBCInput as this requires the rowsetSupport to be enabled.
