A fix is available
APAR status
Closed as program error.
Error description
When an error is returned by a stored procedure, the Loader started task may end with messages: HLOS0909S Started task subtask ESTAE entered System RC=04E HLOS0903S ESTAE Processing completed HLOS0003I Started task termination is in progress HLOS0004I Started task termination is complete
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When loading an index partitioned or * * range partitioned table, the Loader * * sorts the DB2 FORMAT INTERNAL records * * built from the SYSREC. This SORT is * * required for non-parallel load cases * * to order the data by partitioning key. * * When this type of load is run without * * a NUMRECS or SORTKEYS clause, the SORT * * is invoked without a record count. * * This can lead to SORT failures. * * The following message may be seen in * * the joblog: * * ICE046A SORT CAPACITY EXCEEDED * * . * * Additional symptom: * * Abend U0046 (USER COMPLETION CODE=0046) * * module NAME=UNKNOWN * **************************************************************** * RECOMMENDATION: * **************************************************************** Code has been changed to fix this problem
Problem conclusion
Apply the PTF for problem resolution
Temporary fix
Comments
APAR Information
APAR number
PI70993
Reported component name
IDAA LOADER ZOS
Reported component ID
5639OLA00
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-10-19
Closed date
2016-11-23
Last modified date
2017-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HLORUSQA
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R210 PSY UI42870
UP16/12/07 P F612
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":"2.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021