# DB2 components

| [tDB2BulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2bulkexec) | Executes the Insert action on the provided data and gains in performance during<br>Insert operations to a DB2 database. |
| --- | --- |
| [tDB2Close](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2close) | Closes a transaction committed in the connected DB. |
| [tDB2Commit](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2commit) | Commits in one go a global transaction instead of doing that on every row or every<br>batch and thus provides gain in performance. |
| [tDB2Connection](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2connection) | Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs. |
| [tDB2Input](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2input) | Executes a DB query with a strictly defined order which must correspond to the<br>schema definition. Then tDB2Input passes on the field list to the<br>next component via a Row &gt; Main link. |
| [tDB2Output](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2output) | Executes the action defined on the table and/or on the data contained in the<br>table, based on the flow incoming from the preceding component in the Job. |
| [tDB2Rollback](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2rollback) | Avoids to commit part of a transaction involuntarily. |
| [tDB2Row](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2row) | Acts on the actual DB structure or on the data (although without handling data)<br>depending on the nature of the query and the database. The SQLBuilder tool helps you write<br>easily your SQL statements. |
| [tDB2SP](https://help.qlik.com/talend/r/en-US/7.3/components/db2/tdb2sp) | Offers a convenient way to call the database stored procedures. |