IBM Support

PK98416: THE "LOAD DATA INTO DB2" PANEL MAY INCORRECTLY GIVE AN ALAA546E ERROR WHEN THE USER SETS THE "GENERAL REPORT DATA" TO 'N'

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Log Analysis Tool "General report data" field is
    validated using the "Generate details" field from the
    "Generate database activity report" panel when the LOAD
    is made during the same run as the general report and
    detail report.
    
    The "Generate details" field should not be used for validation
    when running a LOAD as a separate job.
    

Local fix

  • * go to the "Generate database activity report" panel and
    * set the "Generate details" field to 'Y'.
      Move through the panels to generate the JCL.
      This will reset the mode file and allow you to
      - go to "Load data into DB2" and
      - use the detail data.
    
      *** Important!  You need to generate the JCL, but don't run
          the JCL because running it will overwrite the data you
          want to LOAD.
    none
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: The DB2 Log Analysis Tool "General      *
    *                      report data" field is validated using   *
    *                      the "Generate details" field from the   *
    *                      "Generate database activity report"     *
    *                      panel when the LOAD is made during the  *
    *                      same run as the general report and      *
    *                      detail report. The "Generate details"   *
    *                      field should not be used for            *
    *                      validation when running a LOAD as a     *
    *                      separate job.                           *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK98416

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2009-10-12

  • Closed date

    2009-12-10

  • Last modified date

    2010-01-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    ALAA07
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R310 PSY UK52770

       UP09/12/17 P F912

  • R320 PSY UK52771

       UP09/12/17 P F912

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"320"}]

Document Information

Modified date:
12 April 2021