IBM Support

PH35265: HCAT_TABLEPARTS() MAY SHOW AN INCORRECT COUNT OF PARTITIONS FOR TABLES WITH MORE THAN 32,676 PARTITIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • The HCAT_TABLEPARTS() view returns a maximum number of
    partitions of 32676 regardless of how many partitions are
    actually in the table. The count returned by the view is
    correct up to 32676 but then stops incrementing.
    

Local fix

  • Determine how many partitions there really are by other means;
    for example, in hive, the LIST PARTITIONS command will list
    all the partitions and will show a count at the end which
    will tell you how many partitions were found.
    

Problem summary

  • Please see the problem description.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH35265

  • Reported component name

    IBM BIG SQL

  • Reported component ID

    5737E7400

  • Reported release

    504

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-03-11

  • Closed date

    2021-04-29

  • Last modified date

    2021-04-29

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"504"}]

Document Information

Modified date:
30 April 2021