A fix is available
APAR status
Closed as program error.
Error description
The Accelerator Loader started task may consume a large amount of CSA below the line storage. The amount of storage consumed may increase over the life of the started task. Additional symptoms: . 1. The Loader started task ends abnormally with message: HLOS0909S Started task subtask ESTAE entered System RC=0C4 . 2. Load job ends with errors: HLOU5713E IDAA stored procedure ACCEL_GET_TABLES_DETAILS returned an error. HLOS0202E DSNT404I SQLCODE = 466, WARNING: PROCEDURE ACCEL_GET_TABLES_DETAILS RETURNED 2 QUERY RESULT SETS . 3. When a load is run using a SYSREC which contains a TIMESTAMP column, rows are discarded that contain a time of 24.00.00.000000. The following messages are produced by the job: HLOU5807W Column TIMESTAMP has invalid data HLOU5816I Total record(s) discarded during data validation=n
Local fix
Turn Audit and Logging off in the Options document by setting AUDIT_ACTIVE="NO" and LOGGING_ACTIVE="NO".
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The Accelerator Loader started task * * consumes CSA storage below the line. * **************************************************************** * RECOMMENDATION: * **************************************************************** The Accelerator Loader started task may consume a large amount of CSA below the line storage. The amount of storage consumed of CSA below the line storage. The amount of storage consumed may increase over the life of the started task. Additional symptoms: 1. The Loader started task ends abnormally with message: HLOS0909S Started task subtask ESTAE entered System RC=0C4 . 2. Load job ends with errors: HLOU5713E IDAA stored procedure ACCEL_GET_TABLES_DETAILS returned an error. HLOS0202E DSNT404I SQLCODE = 466, WARNING: PROCEDURE ACCEL_GET_TABLES_DETAILS RETURNED 2 QUERY RESULT SETS 3. When a load is run using a SYSREC which contains a TIMESTAMP column, rows are discarded that contain a time of 24.00.00.000000. The following messages are produced by the job: HLOU5807W Column TIMESTAMP has invalid data HLOU5816I Total record(s) discarded during data validation=n
Problem conclusion
Code has been modified to correct this issue.
Temporary fix
Comments
APAR Information
APAR number
PI60836
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-04-14
Closed date
2016-06-24
Last modified date
2016-09-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI38942 UI38943
Modules/Macros
HLOBCOMX HLOGMSGF HLORUSQA HLOSINIT HLOSTCMD HLOSTDB2 HLOSTMGR HLOSTMSG HLOSTRES HLOSTSES HLOSTSRV HLOSUSQA HLOUCE15 HLOUMAIN HLOURCES HLOVSSVC
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
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 September 2016