IBM Support

IT24918: DB2 UPGRADE DATABASE APPEARS TO HANG OR RUN VERY SLOW WHEN UPGRADING DATABASE TO V11

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • db2 upgrade database <dbname>
    may run for a very long time if there are Spatial Extender
    indexes defined on the database.
    The more extended / spatial indexes a database has, the longer
    the db2 upgrade will run.
    

Local fix

  • Drop the extended/ spatial indexes prior to the database upgrade
    and recreate them after the database upgrade and the db2se
    upgrade completes.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 11.1 mod 4  Fix Pack 6                *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 11.1 mod 4  Fix Pack 6
    

Temporary fix

  • Drop the extended/ spatial indexes prior to the database upgrade
    and recreate them after the database upgrade and the db2se
    upgrade completes.
    

Comments

APAR Information

  • APAR number

    IT24918

  • Reported component name

    SPATIAL EXTENDE

  • Reported component ID

    5648D6100

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-05-01

  • Closed date

    2022-05-05

  • Last modified date

    2022-05-05

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

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

    IT31952

Fix information

  • Fixed component name

    SPATIAL EXTENDE

  • Fixed component ID

    5648D6100

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSYUVL","label":"DB2 Spatial Extender for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B10"}]

Document Information

Modified date:
06 May 2022