IBM Support

IC73612: IMPROVE THE PERFORMANCE OF SYSPROC.ADMIN_MOVE_TABLE WITH THE COPY_USE_LOAD OPTION BY MAKING IT LOAD USING ANYORDER.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The change that this APAR introduces is to use the ANYORDER file
    type modifier for the load when you call the
    SYSPROC.ADMIN_MOVE_TABLE procedure with the COPY_USER_LOAD
    option.
    You need take no special action to make the
    SYSPROC.ADMIN_MOVE_TABLE procedure use the ANYORDER file type
    modifier for the load.
    Using the ANYORDER file type modifier for the load should
    improve its performance.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of DB2 for Linux, UNIX and Windows who call the        *
    * SYSPROC.ADMIN_MOVE_TABLE procedure with the COPY_USER_LOAD   *
    * option.                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * .                                                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 5.
    At a minimum, this fix should be applied on the server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73612

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-31

  • Closed date

    2011-12-20

  • Last modified date

    2011-12-20

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73612

Modified date: 20 December 2011