DB2 Version 10.1 for Linux, UNIX, and Windows

IBM Data Server Provider for .NET enhancements

The IBM® Data Server Provider for .NET contains a number of enhancements for Version 10.1.

Review the technical changes and new functionality that are included in the following Version 10.1 fix packs. Each fix pack for a release is cumulative: it contains all the technical changes and new functionality that were included in previous fix packs for that release.

Fix Pack 2 enhancements
Fix Pack 1 enhancements

FP2: Support for Microsoft Framework packages and Visual Studio 2012

In Version 10.1 Fix Pack 2 and later fix packs, the IBM Data Server Provider for .NET supports following Microsoft products:

Microsoft .NET Framework 4.5
Microsoft Entity Framework 4.3
Microsoft Visual Studio 2012

FP2: Support for special characters in the password

In Version 10.1 Fix Pack 2 and later fix packs, the IBM Data Server Provider for .NET supports special characters in the password. With some exceptions, an application can specify special characters with ASCII hex values of 0x20 - 0x7e. For more information, see Password rules for drivers and CLPPlus.

FP2: DB2Connection enhancements

In Version 10.1 Fix Pack 2 and later fix packs, you can use the new SystemNaming property to set the system naming mode when connecting to the DB2® for i server. For more information, see DB2Connection.SystemNaming property.

FP2: db2dsdriver.cfg file enhancements

In Version 10.1 Fix Pack 2 and later fix packs, the following features are included in the db2dsdriver.cfg file:

You can specify the specialregisters subsection in the db2dsdriver.cfg file to set any special registers on the server. For more information, see db2dsdriver configuration file.
You can specify multiple paths for the db2dsdriver.cfg file for the DB2DSDRIVER_CFG_PATH registry variable. For more information, see Miscellaneous variables.

FP1: DB2Connection class enhancements

In Version 10.1 Fix Pack 1 and later fix packs, the following features are included in the DB2Connection class:

Support for the caching of *USRLIBL for connections to DB2 for i V6R1 and later, by using the CacheUSRLIBLValue property. For more information, see DB2Connection.CacheUSRLIBLValue Property.
Support for clearing the *USRLIBL cache for connections to DB2 for i V6R1 and later, by using the ClearUSRLIBLCache method. For more information, see DB2Connection.ClearUSRLIBLCache Method.
The host name as the default value for the DB2Connection.ClientWorkStation property. For more information, see DB2Connection.ClientWorkStation Property.
The DelimIdent keyword, which controls whether the connected Informix® database server supports delimited SQL identifiers. For more information, see DB2Connection.ConnectionString Property.

FP1: DB2ConnectionStringBuilder class enhancements

In Version 10.1 Fix Pack 1 and later fix packs, the following properties are included in the DB2ConnectionStringBuilder class:

Support for changing a user's password, with the DB2ConnectionStringBuilder.NewPWD property. For more information, see DB2ConnectionStringBuilder.NewPWD Property.
Support for setting the CURRENT SQLID special register on DB2 for z/OS® by using the new CurrentSQLID IBM Data Server Driver configuration keyword or DB2ConnectionStringBuilder.CurrentSQLID property. For more information, see DB2ConnectionStringBuilder.CurrentSQLID Property.
The ZOSDBNameFilter IBM Data Server Driver configuration keyword and the DB2ConnectionStringBuilder.DBName property for filtering the result of a query on DB2 for z/OS base tables. For more information, see DB2ConnectionStringBuilder.DBName Property.
Support for CERTIFICATE authentication with DB2 for z/OS Version 10 and later. For more information, see DB2ConnectionStringBuilder.Authentication Property.

FP1: Data type support enhancements

In Version 10.1 Fix Pack 1 and later fix packs, the following data type enhancements are included:

SQL data types SQL_BINARY and SQL_VARBINARY are now supported with DB2 for i V6R1 and later. For more information, see SQL data type representation in ADO.NET database applications.
The DB2Decimal structure supports the following new fields:
- E
- MinusOne
- One
- Pi
- Zero
For more information, see DB2Decimal Members.
The DB2Blob and DB2Clob classes support the following new properties:
- EstimatedSize
- IsOpen
- Size
The DB2Blob and DB2Clob classes support the following new methods:
- Read(byte[] buff)
- Read(byte[] buff, Int64 byteOffset, Int64 numBytesToRead, Int64 smartLobOffset, DB2SmartLOBWhence whence)
The DB2Blob class supports the DB2Bob(DB2Connection conn) constructor.
The DB2Clob class supports the DB2Cob(DB2Connection conn) constructor.

FP1: FetchBufferSize keyword support

In Version 10.1 Fix Pack 1 and later fix packs, the IBM Data Server Provider for .NET supports setting the FetchBufferSize keyword to configure the buffer size that is used by fetch requests. For more information, see FetchBufferSize IBM Data Server Driver configuration keyword.

FP1: Enhancements to IBM entity provider

In Version 10.1 Fix Pack 1 and later fix packs, the IBM entity provider supports the following DB2 and Informix functions for LINQ to Entities queries:

Acos
Asin
Atan
Atan2
Cos
Exp
Log
Log10
Sin
SquareRoot
Tan

For more information, see Provider support for Microsoft Entity Framework.

FP1: Anonymous block support enhancements

In Version 10.1 Fix Pack 1 and later fix packs, IBM Data Server Provider for .NET supports the retrieval of the result sets from the execution of anonymous blocks by using the DB2DataReader or DB2ResultSet class.

FP1: Support for Informix data types

In Version 10.1 Fix Pack 1 and later fix packs, IBM Data Server Provider for .NET supports the following Informix features:

The use of the DB2DateTime structure with the Informix database server. For more information, see DB2DateTime Structure.
The new GetDB2DateTime() and SetDB2DateTime() methods for use with the DB2DateTime structure.
The DB2Type enumeration supports Informix data types for use with the Informix database server. For more information, see DB2Type Enumeration.

FP1: Setting of the diaglevel configuration parameter in the db2dsdriver.cfg file

In Version 10.1 Fix Pack 1 and later fix packs, you can use the Diaglevel keyword in the db2dsdriver.cfg file to set the diaglevel diagnostic error capture level configuration parameter. For more information, see Diaglevel IBM Data Server Driver configuration keyword.