PK24485: MSGIEC036I 02-18 IGC0005E WHEN UNLOADING A TABLE WHOSE LRECL EXCEEDS THE MAXIMUM AS DEFINED BY THE ACCESS METHOD. PB 8012

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During an UNLOAD if HPU encounters a record whose
  length exceeds the maximum allowed ( 32760 ) message
  IEC036I 02-18 will be issued by the Access Method and
  the unload will terminate. HPU can do nothing with a
  record that exceeds the maximum, but this apar will
  provide a solution for HPU to issue a message to help
  identify the bad record, and to skip it and finish the
  rest of the unload.
  PB 8012
  UNLOAD PLUS syntax: missing load commands in SYSCNTL when more
  than 10 selects are coded in SYSIN.
  PB 8111
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.During an UNLOAD if HPU encounters a  *
  *                      record whose length exceeds the         *
  *                      maximum allowed ( 32760 ) message       *
  *                      IEC036I 02-18 will be issued by the     *
  *                      Access Method and the unload will       *
  *                      terminate. HPU can do nothing with a    *
  *                      record that exceeds the maximum, but    *
  *                      this apar will provide a solution for   *
  *                      HPU to issue a message to help          *
  *                      identify the bad record, and to skip it *
  *                      and finish the rest of the unload.      *
  *                      PB 8012                                 *
  *                      2.UNLOAD PLUS syntax: missing load      *
  *                      commands in SYSCNTL when more           *
  *                      than 10 selects are coded in SYSIN.     *
  *                      PB 8111                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1.Module Inzrun function inzrunDetermineLrecl() was changed to
  add the control of the maximum record length depending on the
  RECFM of the output file and on the new parmlib variable
  VUU040/ULTR32K. Module Inzplib was changed to read the new
  parmlib variable . New messages INZU297I and INZU298E were
  added to module Inzmsgs.
   - If recorf format is fixed and LRECL > 32760, error message
     INZU298E is issued.
   - If record format is variable and LRECL > 32756:
       - if VUU040/ULTR32K = NO, error message INZU298E is issued.
       - if VUU040/ULTR32K = YES, LRECL is set to 32756 and the
         unload is processed. Some data records may be truncated.
         Informational message INZU297I is issued.
  2.Module inzctrlp was changed: function
  inzcontrolUnpCheckCntlDdn() that checks the presence of ddnames
  in the JCL was fixed.
  

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:

  UK15208 UK15209

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK15208

     UP06/06/14 P F606

• R220 PSY UK15209

     UP06/06/14 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.