Fixes are available
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Closed as program error.
To enable the SELECT of SMALLINT column which is mapped to remote INT. Based on those fix, SELECT SMALLINT from remote INT in Teradata Wrapper behaves as following. 1) If the remote INT value falls in the range of SMALLINT, [-32768,32767], we can get the correct result. 2) If the INT value is out of this range, following error message will be reported. SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003
Users affected: Users of the Teradata wrapper in InfoSphere Federation Server Problem description and summary: See error description.
Problem was first fixed in Version 9.5 FixPak 5 (s091123 ). This fix should be applied on the federation server.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels
22 December 2009