Db2 Iseries Odbc Driver Selection List
The ODBC IBM DB2 Driver configuration dialog opens. Under Options, enter a manual connection string, replacing this example with your own host, libraries, and database name (if applicable):Select IBM DB2 ODBC DRIVER - DB2COPY1 and click Finish. During configuration of a source or target database, select IBM DB2 (AS400) JDBC from the driver selection list. Supports access to IBM DB2 Universal Database, Cloudscape, and Apache Derby.The newly installed driver should now be available in Design Studio. Using a Non-Default Schema for Catalog MethodsPDOODBC currently supports three different flavours of database drivers: ibm-db2.
"DB2 OS/390" refers to all versions of DB2 on OS/390 and z/OS platforms "DB2 UDB" refers to all versions of DB2 running on Windows, UNIX, and Linux/s390 platforms DB2 UDB V4R5, V5R1, and V5R2 running on iSeries and AS/400Note: This documentation uses the following terms to describe the different DB2 versions: DB2 6.1 and DB2 UDB 7.1 running on OS/390 and z/OS via DRDA DB2 Universal Database (UDB) 7.1, 7.2, and 8.1 on Windows NT, Windows 2000, Windows 2003, Windows XP, UNIX, Linux, and Linux/s390 via DRDA Performance Workaround for Batch Inserts and Updates on page 3-20The BEA WebLogic Type 4 JDBC driver for DB2 (the "DB2 driver") supports:
For example, Password is the same as password.A string that is automatically added to all Create Table statements. To specify a property, use the following form in the JDBC data source configuration: property=valueNote: All connection property names are case-insensitive. You can use these connection properties in a JDBC data source configuration in your WebLogic Server domain. DB2 on OS/390, z/OS, iSeries, and AS/4001:Jdbc:bea:db2:// db2_server_name: port Location= db2_location CollectionId= your_collectionnameTable 3-1 lists the JDBC connection properties supported by the DB2 driver, and describes each property. DB2 on Windows NT, Windows 2000, Windows 2003, Windows XP, UNIX, Linux, and Linux/s3901:Jdbc:bea:db2:// db2_server_name: port DatabaseName= your_database
Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.If set to x, where x is a positive integer that specifies the size (in KB) of the memory buffer used to cache insensitive result set data. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently.If set to 0, the driver caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set exceeds available memory, an OutOfMemoryException is generated. It must have one of the following values:If set to -1, the driver caches all insensitive result set data in memory. Determines the amount of memory used by the driver to cache insensitive result set data.
A value of 0 specifies that the timeout is the default system timeout if there is one otherwise it specifies that there is no timeout.See Creating a DB2 Package for more information about creating DB2 packages.A case-sensitive password used to connect to your DB2 database. Specifying a buffer size that is a power of 2 results in more efficient memory use.The name of the DB2 location that you want to access (used with OS/390 and iSeries).The maximum time in seconds that attempts to create a database connection will wait. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.
0 kommentar(er)
