Fixes are available
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
A Federated OLAP query against DB2 for iSeries can fail with an SQL0104N error. For example: SELECT MAX(COL1) OVER (PARTITION BY COL2) FROM MYNICK.TAB1 Unexpected error code "42601" received from data source "MYDB" Associated text and tokens are "func="do_prep" msg=" SQL0104N An unexpected token "(" " The remote query that is pushed down to iSeries is not valid.
Local fix
Can change the query to make it compatible to DB2 for iSeries: Example: SELECT MAX(COL1), RANK() OVER (PARTITION BY COL2 ORDER BY COL2) FROM MYNIC.TAB1 GROUP BY COL1 Another workaround would be to alter the SERVER definition by setting db2_olap_supp to 'N': ALTER SERVER <server name> OPTIONS (ADD db2_olap_supp 'N')
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 3 Fix Pack 3
Temporary fix
Comments
APAR Information
APAR number
JR57507
Reported component name
FEDERATION SERV
Reported component ID
5724N9700
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-02-28
Closed date
2018-03-19
Last modified date
2018-03-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
FEDERATION SERV
Fixed component ID
5724N9700
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022