Oracle DB2 AS/400 JDBC Properties

You can configure the following properties for your DB2 AS/400 database:

Basic

Property	Description
Host
Port
User	Specifies the case-sensitive user name used to connect to your DB2 AS/400 database.
Password	Specifies the case-sensitive password used to connect to your DB2 AS/400 database.
Database	Specifies the name of your DB2 AS/400 database.
Schema	Specifies the schema of the DB2 AS/400 server.
URL	The URL to connect to your DB2 AS/400 database. You cannot edit this field directly, the URL is formed using the host, port and database you define.

Properties

You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.

Note: Connection property names are case-insensitive.

Runtime

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.