PI47919: APAR PI38668 DID NOT DOCUMENT THAT THE VALUES ENTERED ON PANEL WERE NOT SAVED ACROSS SESSIONS BY DESIGN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' APAR PI38668 did not
  including information in the help panels to indicate that the
  data entered on the panels would not be saved.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use help panel ADBHUSU          *
  *                 'HELP for UNLOAD Utility Parameters'.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADBHUSU does not contain          *
  *                      information to explain that DB2 Admin   *
  *                      Tool does not retain the values input   *
  *                      for options HEADER, CONST, SAMPLE       *
  *                      and LIMIT on panel ADB2USU 'Specify     *
  *                      Utility Options - UNLOAD'.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program should be changed to add a note on panel ADBHUSU
  to explain values input for options HEADER, CONST, SAMPLE
  and LIMIT are not retained.
  

Problem conclusion

• Problem has been resolved.
  
  Help panel ADBHUSU has been updated with the following:
  
  HEADER    Allows selection of a constant header field at the
            beginning of output records.  If omitted, DB2 uses
            a default of HEADER OBID.
            Note: The HEADER variable is not saved in the
            ISPF profile.  This variable serves as a data filter
            and might cause loss of data if the previous value
            is inadvertently used.  The user must specify
            HEADER at each use.
  
  CONST     If HEADER is set to C, this field should contain a
            character string or hex string (X'hex string') to be
            used as the header field.
            Note: The CONST variable is not saved in the
            ISPF profile. This variable serves as a data filter
            and might cause loss of data if the previous value
            is inadvertently used.  The user must specify
            CONST at each use.
  
  SAMPLE    Specifies a percentage of rows to be sampled.
            Format is a decimal expression with maximum
            precision of ddd.dddd.
            Examples: 40, 19.6, 22.9999.
            Note: The SAMPLE variable is not saved in the
            ISPF profile.  This variable serves as a data filter
            and might cause loss of data if the previous value
            is inadvertently used.  The user must specify
            SAMPLE at each use.
  
  LIMIT     An integer specifying the maximum number of
            rows to be unloaded.
            Note: The LIMIT variable is not saved in the ISPF
            profile. This variable serves as a data filter and
            might cause loss of data if the previous value is
            inadvertently used.  The user must specify LIMIT
            at each use.
  

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:

  UI32673 UI32674

Modules/Macros

•    ADBHUSU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI32673

     UP15/11/07 P F511

• RB20 PSY UI32674

     UP15/11/07 P F511

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.