PI89989: ABEND U0012 ON HLO#LGAP, HLO#MAIN AND IMAGE COPY LOAD JOB FAILS WITH HLO3601E MESSAGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND U0012 on HLO#LGAP, HLO#MAIN and Image Copy load job fails
  with HLO3601E message:
  ..
  HLO3802E A The Loader row convertion program ended unexpectedly.
  HLO3801E A The Accelerator Loader conversion program returned an
   error.
  HLO3601E  Log apply task returned an error, RC=X'00000C'
  .
  AQT10050I  An internal error occurred on the 'IDAA0004'
   ODBC operation SQ
  AQT10050I  LExecDirect failed with code -1 when executing
   statement:
              INSERT INTO "DB2H
  AQT10050I  OM"."VCL_CTR-UID_2A6900CF" SELECT * FROM EXTERNAL
   '/nz/dwa/var/server/data/
  AQT10050I
   dbs-5/load/task-14104121/table-23289/TETPipe-14104121-2'
   USING (DB2ZPARTITI
  AQT10050I  ONID 1 CONVERTTIME24 true FORMAT 'DB2Z_RRF' LAYOUT
   (INT4,INT2, NUMERIC(17,
  AQT10050I   0), INT2, INT2, NUMERIC(17, 0), INT2, INT2, INT2,
   CHAR(23) BYTES 23, DATE,
  AQT10050I   DATE) LOGDIR
   '/nz/dwa/var/server/data/dbs-5/load/task-14104121/table-23289
  AQT10050I  '):   HY000 46  <
  AQT10050I  Message>ERROR:  External Table : count of bad input
   rows reached maxerrors
  AQT10050I  limit (year is zero, "0x00 0x00 0x00 0x00"  )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
  *                 Loader for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND U0012 on HLO#LGAP, HLO#MAIN and   *
  *                      Image Copy load job fails with          *
  *                      HLO3601E message:                       *
  *                      HLO3802E A The Loader row convertion    *
  *                       program ended unexpectedly.            *
  *                      HLO3801E A The Accelerator Loader       *
  *                       conversion program returned an error.  *
  *                      HLO3601E  Log apply task returned an    *
  *                       error, RC=X'00000C'                    *
  *                      AQT10050I  An internal error occurred   *
  *                       on the 'IDAA0004' ODBC operation SQ    *
  *                      AQT10050I  LExecDirect failed with      *
  *                       code -1 when executing statement:      *
  *                             INSERT INTO "DB2H                *
  *                      AQT10050I  OM"."VCL_CTR-UID_2A6900CF"   *
  *                       SELECT * FROM EXTERNAL                 *
  *                       '/nz/dwa/var/server/data/              *
  *                      AQT10050I                               *
  *                       dbs-5/load/task-14104121/table-23289   *
  *                       /TETPipe-14104121-2'                   *
  *                       USING (DB2ZPARTITI                     *
  *                      AQT10050I  ONID 1 CONVERTTIME24 true    *
  *                       FORMAT 'DB2Z_RRF' LAYOUT               *
  *                       (INT4,INT2, NUMERIC(17,                *
  *                      AQT10050I   0), INT2, INT2, NUMERIC(17, *
  *                        0), INT2, INT2, INT2, CHAR(23) BYTES  *
  *                       23, DATE,                              *
  *                      AQT10050I   DATE) LOGDIR                *
  *                       '/nz/dwa/var/server/data/dbs-5/load    *
  *                       /task-14104121/table-23289             *
  *                      AQT10050I  '):   HY000 46  <            *
  *                      AQT10050I  Message>ERROR:  External     *
  *                       Table : count of bad input             *
  *                       rows reached maxerrors                 *
  *                      AQT10050I  limit (year is zero, "0x00   *
  *                       0x00 0x00 0x00"  )                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    HLO#LGAP
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI52917

     UP18/01/09 P F801

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.