IBM Support

IC75007: THE EXTENT MOVEMENT KEEP ON MOVING EXTENTS EVEN AFTER ISSUING COMMAND "ALTER TABLESPACE <S> REDUCE STOP"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • If you initiated an asynchronous extent movement operation using
    the command "ALTER TABLESPACE <s> REDUCE <n>", it might not be
    possible to stop this operation with command "ALTER TABLESPACE
    <s> REDUCE STOP". You check that using the command LIST
    TABLESPACES: the high water mark value keep reducing even after
    you executed "ALTER TABLESPACE <s> REDUCE STOP".
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 v9.7 FP4 and earlier.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If you initiated an asynchronous extent movement operation   *
    * using                                                        *
    * the command "ALTER TABLESPACE <s> REDUCE <n>", it might not  *
    * be                                                           *
    * possible to stop this operation with command "ALTER          *
    * TABLESPACE                                                   *
    * <s> REDUCE STOP". You check that using the command LIST      *
    *                                                              *
    * TABLESPACES: the high water mark value keep reducing even    *
    * after                                                        *
    * you executed "ALTER TABLESPACE <s> REDUCE STOP".             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 FP5.                                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC75007

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-15

  • Closed date

    2011-12-19

  • Last modified date

    2011-12-19

  • 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

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 December 2011