A fix is available
APAR status
Closed as program error.
Error description
This APAR addresses the following issues: 1) In some instances no limit key values are returned by the server to the client. The UTSN blocks returned to the client have limit key lengths of 0 and contain no limit key data. This causes the records to be incorrectly discarded. 2) There are various problems with the way the partitioning key is built from a SYSREC record. Null indicators are not included in the key, default values are ignored and key columns are not always padded with the correct pad characters. All of these issues can lead to cases where records are incorrectly discarded.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR addresses the following * * issues: * * * * 1. In some instances no limit key * * values are returned by the server t * * the client. The UTSN blocks returne * * to the client have limit key length * * of 0 and contain no limit key data. * * This causes the records to be * * incorrectly discarded. * * 2. There are various problems with the * * way the partitioning key is built * * from a SYSREC record. Null * * indicators are not included in the * * key, default values are ignored and * * key columns are not always padded * * with the correct pad characters. * * All of these issues can lead to * * cases where records are incorrectly * * discarded. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI16437
Reported component name
IDAA LOADER ZOS
Reported component ID
5639OLA00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-04-21
Closed date
2014-05-30
Last modified date
2014-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HLORUSQL
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R110 PSY UI18467
UP14/06/04 P F406
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKRKK","label":"IBM Db2 Analytics Accelerator Loader for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021