IBM Support

PM94061: DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT REPORT SEGSIZE DIFF FOR IMPLICIT TABLESPACE WHEN RUNNING UNDER DB2 FOR Z/OS V10 CM9

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Object Comparison Tool for z/OS does not report SEGSIZE
    difference
    for implicit tablespace when running under DB2 for z/OS V10 CM9
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
    *                 z/OS who include implicit XML table spaces   *
    *                 in the Compare process.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: When comparing implicit XML table       *
    *                      spaces on a DB2 release prior to DB2    *
    *                      10 New Function Mode (NFM), Object      *
    *                      Compare does not report the difference  *
    *                      in SEGSIZE because the SEGSIZE of the   *
    *                      table space can not be altered on DB2   *
    *                      releases prior to DB2 10 NFM.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When comparing implicit XML table spaces on a DB2 release
    prior to DB2 10 New Function Mode (NFM), Object Compare does
    not report the difference in SEGSIZE because the SEGSIZE
    of the table space can not be altered on DB2 releases prior to
    DB2 10 NFM.
    

Problem conclusion

  • The problem has been resolved. Warning message ADB7167W will be
    displayed for the SEGSIZE difference of implicit XML table
    spaces when running Object Compare on a DB2 release prior to
    DB2 10 New Function Mode:
    
    ADB7167W The SEGSIZE of the implicit XML tablespace changed
    from 4 to 32. No change statement will be generated as the
    change cannot be applied by ALTER statement.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM94061

  • 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-07-29

  • Closed date

    2013-09-26

  • Last modified date

    2013-10-04

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

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

Modules/Macros

  • ADB2CMF  ADB7000
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK97962

       UP13/09/28 P F309

  • RA20 PSY UK97937

       UP13/09/28 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.

[{"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:
04 October 2013