suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT17845 Status: Closed

UPGRADE DATABASE COMMAND MIGHT FAIL IN SQLPMIGRATEMFH

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem 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.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001                  *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT17843 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.11.2016
01.05.2017
01.05.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)