MAXPREPAREDSTMTS

Specifies the maximum number of prepared SQL statements that an apply task will maintain simultaneously. A prepared statement is an INSERT, UPDATE, DELETE or MERGE statement used to update a target table.

You should take into consideration that as the specified number increases, it is more likely that an impact on Db2® applications may be observed.

This keyword is optional.

Default Setting—50

Maximum Setting—300

Minimum Setting—50