The following sections detail the database-specific options that can be utilized when using the Micro Focus Database File Handler. These options are set in the database configuration file, by using the dbfhconfig command line utility.
| Option | Description | Example config file entry |
|---|---|---|
| connpool.max=<n> | Specify the maximum number of connection pool connections that can be opened be when OCI connection pooling is enabled. Default 5. Refer to Session Pooling and Connection Pooling in OCI in your Oracle documentation for more details. | <dsn name="ORA.VSAM" type="datastore" dsname="VSAM" dbname="MYDB" connect="myuser/mypassword@MYDB"userid="myuser" dboptions="connpool.use=true, connpool.max=5, connpool.timeout=30"/> |
| connpool.timeout=<n> | Specify the time in seconds after which an idle OCI pooled connection is timed out. If this attribute is not set, or set to 0, the connections are never timed out. Default 0. Refer to Session Pooling and Connection Pooling in OCI in your Oracle documentation for more details. | <dsn name="ORA.VSAM" type="datastore" dsname="VSAM" dbname="MYDB" connect="myuser/mypassword@MYDB"userid="myuser" dboptions="connpool.use=true, connpool.max=5, connpool.timeout=30"/> |
| connpool.use="true|false" | Specify whether OCI connection pooling is to be enabled. If neither OCI connection pooling, nor OCI session pooling is enabled, the default MFDBFH connection caching will be used. Default false. Refer to Session Pooling and Connection Pooling in OCI in your Oracle documentation for more details. | <dsn name="ORA.VSAM" type="datastore" dsname="VSAM" dbname="MYDB" connect="myuser/mypassword@MYDB"userid="myuser" dboptions="connpool.use=true, connpool.max=5, connpool.timeout=30"/> |
| sesspool.max=<n> | Specifies the maximum number of sessions that can be opened in a session pool when OCI session pooling is enabled. Default 5. Refer to Session Pooling and Connection Pooling in OCI in your Oracle documentation for more details. | <dsn name="ORA.VSAM" type="datastore" dsname="VSAM" dbname="MYDB" connect="myuser/mypassword@MYDB"userid="myuser" dboptions="sesspool.use=true, sesspool.max=15"/> |
| sesspool.use="true|false" | Specify whether OCI session pooling is to be enabled. If neither OCI connection pooling, nor OCI session pooling is enabled, the default MFDBFH connection caching will be used. Default false. Refer to Session Pooling and Connection Pooling in OCI in your Oracle documentation for more details. | <dsn name="ORA.VSAM" type="datastore" dsname="VSAM" dbname="MYDB" connect="myuser/mypassword@MYDB"userid="myuser" dboptions="sesspool.use=true, sesspool.max=15"/> |
The following examples show how to set some of these options using the dbfhconfig command:
dbfhconfig -add -server:MYSRV -dsn:ORA.DATS -type:datastore -name:VSAM -dbopts:"connpool.timeout=120"