APAR status
Closed as program error.
Error description
DB2 Enterprise stage gives error Fatal: main_program: REAL : this type is not supported when writing a column type REAL to a DPF DB2 table.
Local fix
Use column type DOUBLE
Problem summary
**************************************************************** USERS AFFECTED: DB2 Enterprise Stage **************************************************************** PROBLEM DESCRIPTION: DB2 Enterprise Stage job returns "REAL: this type is not supported" error when target DB2 database is DPF and REAL data type is defined as a partitioning key. **************************************************************** RECOMMENDATION: Apply the patch for JR37597. ****************************************************************
Problem conclusion
Checking REAL data type was missing from DB2 partitioner. It should be mapped to SQL_TYP_FLOAT during partitioning key processing.
Temporary fix
Comments
APAR Information
APAR number
JR37597
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-26
Closed date
2010-09-03
Last modified date
2010-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
PXDB2
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 September 2010