DB2 CONNECT / DB2CONNCT / 970 - DB2

After upgrading to DB2 v9.7 FP5 and using the DB2 .NET Entity 
provider with the Microsoft Visual Studio Entity Framework 
Modeller - Linq Data Source, and exception can occur as follows: 
 
[NotSupportedException: The connected server doesn't support 
"Top" expression.] 
IBM.Data.DB2.Entity.SqlGenerator.Visit(DbLimitExpression e) +196 
System.Data.Common.CommandTrees.DbLimitExpression.Accept(DbExpre 
ssionVisitor`1 visitor) +20 
IBM.Data.DB2.Entity.SqlGenerator.a(DbExpression A_0, String A_1, 
TypeUsage A_2, Symbol& A_3) +86 
IBM.Data.DB2.Entity.SqlGenerator.Visit(DbProjectExpression e) 
+162 
System.Data.Common.CommandTrees.DbProjectExpression.Accept(DbExp 
ressionVisitor`1 visitor) +20 
IBM.Data.DB2.Entity.SqlGenerator.a(DbExpression A_0, Boolean 
A_1) +148 
IBM.Data.DB2.Entity.SqlGenerator.b(DbExpression A_0) +45 
IBM.Data.DB2.Entity.SqlGenerator.a(DbQueryCommandTree A_0, 
Hashtable& A_1, ArrayList& A_2, String[]& A_3) +491 
IBM.Data.DB2.Entity.SqlGenerator.GenerateSql(DbCommandTree tree, 
DB2ProviderManifest manifest, List`1& parameters, CommandType& 
commandType, Hashtable& 
IBM.Data.DB2.Entity.DB2ProviderServices.a(DbProviderManifest 
A_0, DbCommandTree A_1) +491 
IBM.Data.DB2.Entity.DB2ProviderServices.CreateDbCommandDefinitio 
n(DbProviderManifest manifest, DbCommandTree commandTree) +132 
System.Data.Common.DbProviderServices.CreateCommandDefinition(Db 
CommandTree commandTree) +84 
System.Data.EntityClient.EntityCommandDefinition..ctor(DbProvide 
rFactory storeProviderFactory, DbCommandTree commandTree) +333

**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows users using DB2 .NET                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpak 6                         * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7, Fixpak 6

n/a

forerunner  : APAR is sysrouted TO one or more of the following: IC84228 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.12.2011
15.06.2012
15.06.2012

9.7.