PM85137: PANEL ADB2USU 'LAST IC' FIELD LAST RESULTS IN ZERRMSG ISPF105 FUNCTION ADB2U LINE 2388: FTINCL ADB2UTUL OUTPUT OVERFLOW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB2USU 'Specify
  Utility Options - UNLOAD' field 'Last IC' accepts a value of
  'Last' which will result in a message:
  Function : ADB2U , LINE 2388: FTINCL ADB2UTUL
  Retcode  : 20
  Zerrmsg  : ISPF105
  Zerrsm   : Output overflow
  Zerrlm   : Line to be written greater than data set LRECL (80),
  ADB2UTULrecord-332
  
  when the utility is attempted against a table with a long name.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use panel ADB2UT 'Table Utilities'  *
  *                 to UNLOAD data from a table.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADB2USU 'Specify Utility Options  *
  *                      - UNLOAD' field 'Last IC' accepts a     *
  *                      value of 'Last' which will result in    *
  *                      a message:                              *
  *                                                              *
  *                      Function : ADB2U ,                      *
  *                      LINE 2388: FTINCL ADB2UTUL              *
  *                      Retcode  : 20                           *
  *                      Zerrmsg  : ISPF105                      *
  *                      Zerrsm   : Output overflow              *
  *                      Zerrlm   : Line to be written greater   *
  *                                 than data set LRECL (80),    *
  *                                 ADB2UTULrecord-332           *
  *                                                              *
  *                      when the utility is executed on a       *
  *                      table with a long name.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the 'LAST IC' value is set to 'Last', and the template
  name generated for SYSPUNCH and SYSREC is more than 80
  characters, the UNLOAD statement is not generated for the
  table with a long name.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK94516 UK94517

Modules/Macros

• ADB2U    ADB2UCU2 ADB2UCU9 ADB2UTUL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK94516

     UP13/05/25 P F305

• RA20 PSY UK94517

     UP13/05/25 P F305

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.