IT17844: UPGRADE DATABASE COMMAND MIGHT FAIL IN SQLPMIGRATEMFH

DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• On some occasion, it is possible that UPGRADE DATABASE command
  fails "SQL1042C  An unexpected system error occurred" while
  reporting an error similar to
  
          2016-11-02-16.29.13.231876-300 I171674A764
  LEVEL: Severe
          PID     : 22640                TID : 1642           PROC
  : db2sysc 0
          INSTANCE: xxxxxxxx             NODE : 000           DB
  : xxxxxxxx
          APPHDL  : 0-2476               APPID:
  *LOCAL.xxxxxxxx.161102212913
          AUTHID  : xxxxxxxx             HOSTNAME: xxxxxxxx
          EDUID   : 1642                 EDUNAME: db2agent
  (xxxxxxxx) 0
          FUNCTION: DB2 UDB, data protection services,
  sqlpMigrateMFH, probe:70
          MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal
  Logic Error"
                    DIA8526C A fatal error occurred in data
  protection services.
          DATA #1 : String, 66 bytes
          Unable to migrate as MFH records do not have consecutive
  counters.
          DATA #2 : unsigned integer, 2 bytes
          0
          DATA #3 : unsigned integer, 2 bytes
          65535
  
          2016-11-02-16.29.13.234006-300 I172439A770
  LEVEL: Severe
          PID     : 22640                TID : 1642           PROC
  : db2sysc 0
          INSTANCE: xxxxxxxx             NODE : 000           DB
  : xxxxxxxx
          APPHDL  : 0-2476               APPID:
  *LOCAL.xxxxxxxx.161102212913
          AUTHID  : xxxxxxxx             HOSTNAME: xxxxxxxx
          EDUID   : 1642                 EDUNAME: db2agent
  (xxxxxxxx) 0
          FUNCTION: DB2 UDB, data protection services,
  sqlpMigrateMFH, probe:70
          MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal
  Logic Error"
                    DIA8526C A fatal error occurred in data
  protection services.
          DATA #1 : String, 26 bytes
          Unable to migrate MFH file
          DATA #2 : unsigned integer, 4 bytes
          1
          DATA #3 : Hex integer, 4 bytes
          0x00000D00
          DATA #4 : Pointer, 8 bytes
          0x0000000000000000
  
  Despite the message, the counters are consecutive, but we fail
  to detect it correctly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 10.1 Fix Pack 6                               *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 10.1 Fix Pack 6
  

Temporary fix

Comments

APAR Information

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

  IT17843

• 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