IBM DB2 Non-Spatial (JDBC) Writer Parameters
Database Connections |
---|
Connections store authentication information. For general information about sharing database connections, please seeUsing Database Connections. Note that different subsets of Database Connection parameters are made available in different contexts. ![]() Select an existing connection, orAdd Database Connectionto define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users. |
Connection Parameters
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
The host name of the IBM DB2 Database.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
The connection port for the IBM DB2 Database.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
The name of the database to connect to.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
Enter the username and password to access the database, user account, or wherever authentication is required.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
This parameter determines the number of features that FME will place in each transaction before a transaction is committed to the database.
The default value is 1000.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/db2_jdbc_nonspatial/../Skins/Default/Stylesheets/Images/transparent.gif)
The time, in seconds, after which to terminate a query to the database if it has not yet returned a result.
If set to 0, there is no timeout. The default is 30.
Note:If this value is not set high enough, then the query will return the errorProvider Error - Timeout Expired.