" " Transaction processing (TP) monitor

Transaction processing (TP) monitors are used to improve performance in OLTP environments. Many users can share a smaller number of database connections in order to execute transactions.

TP monitors can also be used to coordinate multisite updates across heterogenous resources. For example, a TP monitor can coordinate a single transaction involving updates to a DB2 for OS/390 server and an update to a print queue.

When TP monitors are used to coordinate multisite updates, the transaction states are maintained by the TP monitor itself, not by the native DB2 transaction manager. Therefore, in this environment there is no need for a TM database.

Database configuration parameter: Transaction Processing Monitor Name (TM_MON_NAME)



U

" " User mapping

A user mapping is an association between the userid and password under which a user or application connects to a federated database and the userid and password under which the user or application connects to a data source.



W

" " Workload

A workload consists of a number of SQL statements that are run against a database. Each SQL statement in the workload is given a frequency. The Create Index wizard uses the specified workload to determine which indexes to recommend and create.

" " Wrapper

A wrapper is the mechanism that the federated system uses to communicate with, and retrieve data from, a data source. To implement a wrapper, the server uses routines stored in a library or dll called a wrapper module. These routines allow the server to perform such operations as connecting to a data source and retrieving data from it iteratively.

The federated server uses the following wrappers: