PI60836: THE ACCELERATOR LOADER STARTED TASK CONSUMES EXCESSIVE CSA STORAGE BELOW THE LINE

Obtain the fix for this APAR.

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 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

• R110 PSY UI38942

     UP16/07/01 P F606

• R210 PSY UI38943

     UP16/07/01 P F606

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.