Fixes are available
APAR status
Closed as program error.
Error description
DB2 may produce -901 error with  "unexpected error at MinMaxPartialEvaluator.cpp:98" when the following conditions are satisfied: 1. Default string units are CODEUNITS32. 2. The query implicitly casts non-string values (e.g. numerical, datetime, boolean) to VARCHAR. 3. The query contains columnar tables. 4. There exists a MIN or MAX aggregate function over the implicit cast. For example:     UPDATE DB CFG FOR TESTDB USING STRING_UNITS CODEUNITS32;     CREATE TABLE T( I INT ) ORGANIZE BY COLUMN;     SELECT MAX( I || '' ) FROM T;
Local fix
Modify the above query to perform an explicit cast to VARCHAR: SELECT MAX( CAST( I AS VARCHAR(20) ) || '' ) FROM T;
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * server side fix * ****************************************************************
Problem conclusion
Problem was fixed in DB2 VERSION 111 fix pack XX
Temporary fix
see local fix
Comments
APAR Information
APAR number
IT26685
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-19
Closed date
2021-03-19
Last modified date
2021-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
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022