IBM Support

IT31956: ADMIN_MOVE_TABLE: REPORT MAY RETURN UNREASONABLE HIGH VALUES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • ADMIN_MOVE_TABLE with REPORT functionality might return
    unreasonable / unrealistic values for
    
    REPLAY_THROUGHPUT
    INFLOW_STAGING
    OUTFLOW_STAGING
    
    We have recently seen unrealistic high values which exceed
    MAXINT. For example the following was reported:
    
    db2 "CALL SYSPROC.ADMIN_MOVE_TABLE( 'SSSSS', 'TTTTT', ' ', ' ',
    'REPORT' )"
    
    
     Result set 1
     --------------
    
     STATUS         AGENT_ID       INIT_START
    COPY_THROUGHPUT   COPY_ECT          ROWS_STAGING
    REPLAY_THROUGHPUT  INFLOW_STAGING    OUTFLOW_STAGING
    GROWTH_STAGING    REPLAY_ECT
     ---------------------- --------------------
    -------------------------- --------------------
    -------------------------- --------------------
    -------------------- -------------------- --------------------
    -------------------- --------------------------
     REPLAY                 845 2020-02-11-05.56.58.780090
    2458 -                    3044181    82885108932031
    82885108932044    82885108932031          13
    9999-12-31-23.59.59.999999
    
    This APAR should simplify the calculation of this monitoring
    values and make the code more robust.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ADMIN_MOVE_TABLE calls with ESTIMATE options.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to next fixpack.                                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT31956

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-24

  • Closed date

    2020-03-25

  • Last modified date

    2020-03-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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 March 2020