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