| Property | Description |
|---|---|
| Host | Specifies the database server host. |
| Port | Specifies the port of the database host. |
| User | Defines user ID you want to use to connect to the database. This user must already exist in DB2 and have permissions to create the schema and tables used to store information. |
| Password | Specifies password for the user. |
| Database | Specifies the database you wish to connect to. |
| Schema | Specifies the database schema to use. (optional) |
| URL | Defines the URL for the database entry. |
You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.
| Property | Description |
|---|---|
| Maximum Pool Size | Determines the maximum number of connections that can be created within the connection pool. |
| Maximum Connections Per User | Determines the maximum number of connections that can be created per user. |
| Connection Idle Time (minutes) | Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically. |
| Minimum Pool Size | Determines the minimum number of connections that can be created within a connection pool. |
| Maximum Opened Cursors | Determines the maximum number of cursors that can be opened at one time. |