PK78465: CREATE TABLE DDL CONTAINS PARTITION BY "" ( NO VALUE FOR LIMIT KEY )

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as duplicate of another APAR.

Error description

  • The DB2 Object Comparision Tool generated CREATE TABLE DDL
    without a value for the LIMITKEY in the PARTITION BY clause.
    
    For example:
    PARTITION BY ("" ASC,
                  "" ASC )
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • PK78465 is fixed by PK98472(UK52001)
    
    USERS AFFECTED
    Users of DB2 Object Comparison Tool for z/OS
    who use generic ignore field PARTITIONING to
    ignore the difference between partitioned
    and non partitioned tables.
    
    PROBLEM DESCRIPTION
    The generic ignore field PARTITIONING
    includes following ignore fields:
    INDEXPART.LIMITKEY
    TABLEPART.LIMITKEY
    TABLEPART.LIMITKEY_INTERNAL
    TABLEPART.LOGICAL_PART
    TABLES.PARTKEYCOLNUM
    COLUMNS.PARTKEY_COLSEQ
    COLUMNS.PARTKEY_ORDERING
    
    RECOMMENDATION
    Apply The PTF.
    
    PROBLEM SUMMARY
    Column names in the PARTITION BY clause within the CREATE TABLE
    statement are not generated correctly when comparing partitioned
    and non partitioned tables, as well as when using the generic
    ignore field PARTITIONING to ignore the difference without
    specifying the ignore field SYSCOLUMNS:PARTKEY_COLSEQ.
    
    PROBLEM CONCLUSION
    The problem has been fixed.  The following fields have been
    added to the generic ignore field PARTITIONING :
    INDEXPART.LIMITKEY
    TABLEPART.LIMITKEY
    TABLEPART.LIMITKEY_INTERNAL
    TABLEPART.LOGICAL_PART
    TABLES.PARTKEYCOLNUM
    COLUMNS.PARTKEY_COLSEQ
    COLUMNS.PARTKEY_ORDERING
    

APAR Information

  • APAR number

    PK78465

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    720

  • Status

    CLOSED DUB

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-12

  • Closed date

    2009-11-25

  • Last modified date

    2009-11-25

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

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

Fix information

Applicable component levels



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
DB2 Object Comparison Tool

Software version:

7.2.0

Reference #:

PK78465

Modified date:

2009-11-25

Translate my page

Machine Translation

Content navigation