DB2 10.5 for Linux, UNIX, and Windows

Features by fixpack

These tables lists the features that have been delivered for each type of server and by fixpack.

The following tables are an overview of all driver features delivered in each fixpack. The columns are divided by type of server, while the rows are divided by type of driver. This is intended to be a high-level overview and does not provide details for each feature.

DB2 V10.5 Features by Fixpack
DB2 V10.1 Features by Fixpack
DB2 V9.7 Features by Fixpack
DB2 V9.5 Features by Fixpack

Blank cells indicate that there was no specific enhancements to highlight that is specific to the driver and server combination.

Table 1. features by fixpack, V10.5
Fixpack Level	API	All Servers	DB2 for Linux, UNIX, Windows	DB2 for z/OS	Informix	IBM i
V10.5 GA	Features for all listed drivers	db2cli validate all	alternate group failback for HADR	commit on EOF default true for V9 and above		unlimited edition host based license for V7R1 and later
	ODBC	ability to specify db2dsdriver.cfg name batching for CALL includes result set steam lob output parms from stored procs	override affinity API	override affinity API		*USERLIB cache refresh date / time formats and separator
	DB2 .NET	Entity Framework 5.0 support
	Visual Studio add-ins	Entity Framework 5.0 support
	embedded	decfloat (AIX)	generic special registers	generic special registers
	CLPPlus	option to preserve blanks autocommit for ddl message locale different from OS locale	CODEUNIT 32
V10.5 FP1	Features for all listed drivers		JSON
V10.5 FP2	Features for all listed drivers	limit seamless retries to 1 vs 10		V11 CALL with ARRAY V11 global session variables V11 larger client info fields V11 implicit commit for procedures V11 client consistency token V11 default disconnect on interrupt V11 APPLCOMPAT bind option
	ODBC	document SQL_DESC_IDENTITY_VALUE		support RELEASE in SQLCreatePkg
	DB2 .NET	property for server function path
	Visual Studio add-ins	property for server function path
	JCC	combine all SETs in one EXCSQLSET command timeout to cursor and metadata IDAA current query explicit parm
V10.5 FP3	Features for all listed drivers			JSON
DB2® Cancun Release 10.5.0.4	Features for all listed drivers	add OLE DB to validate page db22connectactivate to provide updated info TLS 1.2 support	BINARY, VARBINARY	db2cli BIND with GRANT db2cli option to show DB2 Connect license used
	ODBC	db2trc dump statements when turned on db2cli validate odbcdsn option request read only conneciton MERGE to use array input getinfo to return config file parameters db2trc - tracepathname	CODEUNIT 32 seamless failover autodetect readonly	seamless failover autodetect readonly		CALL with ARRAY global variables currently committed
	DB2 .NET	BatchCommandTimeout to connection object IDBConnectionExtension for SSRS step-by-step for use of merge modules	CODEUNIT 32 seamless failover autodetect readonly	seamless failover autodetect readonly	support procedure with RETURNING in Entity Framework and Server Explorer	CALL with ARRAY global variables currently comitted
	Visual Studio add-ins	step-by-step for use of merge modules Visual Studio 2013	CODEUNIT 32		support procedure with RETURNING in Entity Framework and Server Explorer
	CLPPlus	support SERVER_ENCRYPT_AES define editor with no space		ability to get expiry and version of client side license T2 client info size and correlation token

Table 2. features by fixpack, V10.1
Fixpack Level	API	All Servers	DB2 for Linux, UNIX, Windows	DB2 for z/OS	Informix	IBM i
V10.1 GA	Features for all listed drivers	removed legacy JDBC driver
	ODBC				connection timeout default changes
	DB2 .NET	skipsynonym default on useisnullsp, namedparameters inactive
	Visual Studio add-ins
	CLPPlus		allow connections to Express			allow connection to IBM i
V10.1 FP1	Features for all listed drivers	forward fit V9.7 FP6
	ODBC
	DB2 .NET
	Visual Studio add-ins
V10.1 FP2	Features for all listed drivers	30108 member info and reason code generic set special registers multiple entries in dsdriver cfg path db2cli bind command special chars in password	sysplex stats to match JCC ACR to not look for an active transport member stats pureScale rolling updates	sysplex stats to match JCC ACR to not look for an active transport member stats		system naming support
	ODBC	querytimeoutintyerval only 0 or 1 provide db2dsdriver.cfg name with install ability to update ODBC dsns with install LU validate page SQL_CLOSE to free memory also
	DB2 .NET	Entity Framework 4.3 support Framework 4.5	sysplex stats to match JCC ACR to not look for an active transport member stats pureScale rolling updates
	Visual Studio add-ins	Visual Studio 2012				decfloat support
	CLPPlus	SELECT * with no space specify font and size for window option	32K default pagesize on create db
	Embedded	command timeout in db2dsdriver.cfg

Table 3. features by fixpack, V9.7
Fixpack Level	API	All Servers	DB2 for Linux, UNIX, Windows	DB2 for z/OS	Informix	IBM i
V9.7 GA	ODBC	dbchar to numeric bindout conversions rollback during streaming interleaved fetch during streaming	hostvar syntax for parameter markers currently committed no bind-in retry 9.5 and later servers anonymous block statement concentrator CALL with named parameters variable length timestamp CREATE or REPLACE syntax describe only for CURSOR, ROW, BOOLEAN	seamless XA for sysplex client affinity	MACH 11 WLB BIGINT, BIGSERIAL
	DB2 .NET	remove Framework 1.1 provider remove any accidental db2cli.ini support program name and program id seti properties	currently committed ARRAY input parm to SQL procedures anonymous blocks hostvar syntax for parm markers variable length timestamp	seamless XA for sysplex	MACH 11 HADR MACH 11 WLB BIGINT, BIGSERIAL result set from RETURN
	Visual Studio add-ins	pureQuery static profiling assist Visual Studio DB2 .NET 2003 dropped	variable length timestamp hostvar syntax anonymous block		BIGSERIAL BIGINT
V9.7 FP1	ODBC	env var for db2dsdriver.cfg location db2trc integration for cli trace interleaved insert with streaming ReloadConfig for ACR section failback to primary pureQuery, client optimization with pdqxml file	ReloadConfig for ACR section module support pureScale WLB ACR OPM Extended Insight first delivery	V10 binary XML V10 greater length timestamp V10 currently committed	ODBC support documented
	DB2 .NET	LINQ schema filtering env var for db2dsdriver.cfg location	statement concentrator	V10 binary XML V10 greater length timestamp V10 currently committed	optimizer directives
	Visual Studio add-ins	ARRAY input parameter to SQL Procs and in procedure designer full alter of procedures LINQ over XML reference		V10 greater length timestamp V10 currently committed
V9.7 FP2	ODBC	pureQuery client optimization capture only mode command line register ODBC ds codepage per conn handle db2cli validate support COLLECTION for SQLCreatePackage FET_BUF_SIZE - up to 256k	OPM Extended Insight validate diagnostics result sets from anonymous blocks	OPM Extended Insight Beta direct and gateway OPM Extended Insight static SQL beta V10 explain, extended indicators V10 timestamp with timezone
	DB2 .NET	client info settings in db2dsdriver.cfg 32-bit provider in 64-bit builds MS LINQ filtering and simple canonical functions override for with hold property on cursors	OPM Extended Insight beta extended Indicators MODULE support	OPM Extended Insight Beta direct and gateway OPM Extended Insight static SQL beta V10 explain, extended indicators V10 timestamp with timezone
	Visual Studio add-ins	debugger support for timestamp(p) and decfloat 32-bit provider in 64-bit builds	MODULE support debugger support for ARRAY	V10 explain and timestamp with timezone
	CLPPlus	console handling improvements support db2dsdriver.cfg for alias and kerberos COPY command	ref cursors bind variables SHOW ERROR
V9.7 FP3	Features for all listed drivers			V10 support connect unlimited licensing	Informix 11.70 trusted context
	ODBC	instance client uses db2dsdriver.cfg Optim raw codepage network stats last member on connection GetPositionW	SQLCreateDB	Extended Insight supported	workload mgmt session vars
	DB2 .NET	LINQ canonical functions Framework 4.0 beta	CURSOR as OUT param	Extended Insight supported
	Visual Studio add-ins	Visual Studio 2010 beta			stored proc debugger
	CLPPlus	CLP DESCRIBE style UTF-8 console comment, interrupt, line editor SET SERVEROUTPUT COLUMN NEWVALUE general purpose	WHENEVER NUMBER, VARCHAR2	bind variables	bind variables
V9.7 FP4	Features for all listed drivers	db2diag -a in ds driver tcpipConnectTimeout	cache of wlb list for use at startup MemberConnectTimeout	sysplex support across migration MemberConnectTimeout
	ODBC	db2cli(32) in 64-bit drivers validate to show unrecognized values cli load with async	binary XML	temporal describe
	DB2 .NET		DB2 .NET 4.0, Entity Framework 4.0 GA instance clients to use db2dsdriver.cfg high precision ts and decfloat in a dataset removal of U2 support and ucinet
	Visual Studio add-ins	Visual Studio 2010 GA
	CLPPlus	bind package escape character command line silent mode	row array or row runstats reorgchk, reorg autotrace boolean
V9.7 FP5	Features for all listed drivers	schema filter in conn string password in db2dsdriver.cfg file command line to add entry to db2dsdriver.cfg db2cli to show copy type and name	net stats server time on commit, rollback alternate group failover	password up to 100 chars alternate group failover		XML extended indicator for unassigned
	ODBC	ignore dbalias if database present commit on EOF setting ODBC 3.8 version, pool, end tran attribute for warning on seamless failover db2cli registerdsn to support catalog aliases individual row update count in batch settable codepage for allcharacter based columns reloadconfig to return diagnostic string	temporal describe	columnwise MRI
	DB2 .NET	block for n rows capability on command ability to disable auto-rebind MS trace integration transaction savepoint support currentpackageset, querytimeout and connect node from db2dsdriver.cfg CommandBuilder.CompareRowVersion array input commit on EOF setting	cache of server list alternate server list for first connect ConnectNodeNumber from db2dsdriver.cfg temporal describe	temporal describe support (V10)	workload management session vars program name and program id client info	*NONE isolation level
	Visual Studio add-ins	debugger visualizers for lobs console window independent of project		debugging for PL/SQL cursor as OUT param		XML Schema functions
	CLPPlus	SERVER_ENCRYPT LDAP TRIMSPOOL, TRIMOUT IMPORT from client machine	create, drop database	AUTOTRACE	AUTOTRACE
	Embedded		fetch into array (for Pro*C)
V9.7 FP6	Features for all listed drivers	SSL with auth client db2cli validate to show list of client packages on Windows db2profile for ds driver default value of hostname for workstation name connect activate to handle OPM in stored proc db2cli registerdsn remove alldsn db2cli to warn on duplicates ds driver to update path, classpath ei monitor sp ei load pqcmx from default location	prefetched cursor support for seamless	prefetched cursor suport for seamless ACR 7003 for commit on EOF		update server libraries with schema list binary, varbinary client info
	ODBC	LDAP settings from db2dsdriver.cfg cli driver to support NOMAP	CURSOR as OUT param array insert in trusted procs
	DB2 .NET	Command.DeriveParameters newpwd connection string parameter pureQuery to use pdqxml promoteable local to XA LINQ store specific functions fetch buffer size support	result set from anonymous block binary XML w/o parse, serialize for V10.1	current sqlid keyword DBName property	DB2 .NET same Informix support as Informix DB2 .NET	decfloat for V6R1
	Visual Studio add-ins	quicklinks to DS tooling create table from import newpwd connection string parameter		DBName property in add conn dialog
	CLPPlus	end to end monitoring http urls as script location Oracle compat for use in data studio	prefetched cursor support for seamless

Table 4. features by fixpack, V9.5
Fixpack Level	API	All Servers	DB2 for Linux, UNIX, Windows	DB2 for z/OS	Informix	IBM i
V9.5 GA	ODBC	cli driver available
	DB2 .NET				initial support
	Visual Studio add-ins	Visual Studio 2008 compatibility			initial support
V9.5 FP1	ODBC
	DB2 .NET		trusted context	database names up to 18 character	database names up to 18 character
	Visual Studio add-ins
V9.5 FP2	ODBC	interleave putdata attribute	Secure Sockets Layer (SSL)	SSL		SSL
	DB2 .NET	SSL Enterprise Library LINQ Entity Framework Beta			sqleseti API progressive reference data retrieval
	Visual Studio add-ins	Visual Studio 2008 Windows Presentation Foundation (WPF) Windows Workflow Foundation (WWF)	complete debugging, V8 server	complete debugging, V8 server	procedure / function edit / clone
V9.5 FP3	ODBC	ds driver available SQLCreatePkg() function SQLRowCount() function ping capabilities enhanced	Advanced Encryption Standard (AES) algorithm encryption	AES algorithm encryption client sysplex	MACH 11 HADR long database names	AES algorithm encryption
	DB2 .NET	pureQuery static profiling (db2cap) LINQ Entity Framework GA		client sysplex	long database names
	Visual Studio add-ins	schema node in server explorer