IBM Support

PM87326: EXCLUDED OBJECT UNLOADED IN ERROR.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS creates an UNLOAD for
    an object listed in an ADB7132W message:
    ADB7132W Table >schema<.>table< is specified in source
    exclude specification. This object is excluded.
    

Local fix

Problem summary

  •   USERS AFFECTED: Users of the DB2 Object Comparison Tool for
                      z/OS who compare two tables and the table
                      on the target is excluded from the compare
                      process.
    
      PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for
                           z/OS, when comparing two tables and
                           using the Exclude function to exclude
                           the table on the target from the
                           compare process, and specifying 'No'
                           for the option 'Allow implicit DROP
                           of excluded objects' on panel GOC5
                           'Generate Compare Jobs', an
                           extraneous UNLOAD statement for the
                           table space which contains the table
                           is generated.  The following
                           warning message ADB7132W /
                           msgadb7132w is observed:
    
                           ADB7132W Table >schema<.>table<
                           is specified in source exclude
                           specification. This object is
                           excluded.
    
      RECOMMENDATION:
    
    DB2 Object Comparison Tool for z/OS should not generate an
    UNLOAD for a table space if the table meets the following
    conditions:
    
    - The table is on the target
    - The table is excluded from the compare process
    - Dropping the table implicitly is not allowed.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87326

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-18

  • Closed date

    2013-06-17

  • Last modified date

    2013-07-03

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

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

Modules/Macros

  • ADB2CMF
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA20 PSY UK95055

       UP13/06/19 P F306

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 July 2013