PM90654: 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' APAR PM85137 did not
  deliver a complete solution to the issue being addressed by the
  APAR:
  PANEL ADB2USU 'LAST IC' FIELD LAST RESULTS IN ZERRMSG ISPF105
  FUNCTION ADB2U LINE 2388: FTINCL ADB2UTUL OUTPUT OVERFLOW
  
  as the ++HOLD modifications to the ADB2UCUS member were not
  complete.
  

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: The DB2 Administration Tool for z/OS    *
  *                      panel ADB2USU 'Specify Utility Options  *
  *                      - UNLOAD' field 'Last IC' accepts a     *
  *                      value of 'Last' which results 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 UNLOAD utility is used         *
  *                      against a table with a long name.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When specifying 'Last' for the 'LAST IC' option on panel
  ADB2USU, the template name generated for SYSPUNCH and SYSREC
  may be longer than 80 characters, therefore, panel ADB2U can
  not successfully invoke skeleton ADB2UTUL to generate the
  UNLOAD statements for this long table name.
  

Problem conclusion

• Problem has been resolved.
  If you have applied APAR PM85137, please submit SADBSAMP member
  ADB2UC11 on DB2 Administration Tool for z/OS Version 10,
  Release 1 or SADBSAMP member ADB2UCU4 on DB2 Administration
  Tool for z/OS Version 10, Release 2 to update the ADB2UCUS in
  your environment.
  

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:

  UK97527 UK97528

Modules/Macros

• ADB2UCU4 ADB2UC11 ADB2UTUL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK97527

     UP13/09/18 P F309

• RA20 PSY UK97528

     UP13/09/18 P F309

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.