IBM Support

IC77062: UPGRADE DB FAILS WITH SQL1226N DUE TO DEFERRED MDC ROLLOUT CLEANUP

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • UPGRADE DB command fails with SQL1226N due to deferred MDC
    rollout cleanup.
    
    The problem is caused by have outstanding async index cleanup to
    perform that were the result of deferred MDC rollout deletes.
    
    db2diag.log has the following error messages.
    
    2011-05-23-10.29.31.209047-240 I1952E262           LEVEL:
    Warning
    PID     : 32668                TID  : 47232692838320PROC : db2bp
    INSTANCE: db2inst1             NODE : 001
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:1
    MESSAGE : Restore flag is false
    
    2011-05-23-10.29.31.209439-240 I2215E262           LEVEL:
    Warning
    PID     : 32668                TID  : 47232692838320PROC : db2bp
    INSTANCE: db2inst1             NODE : 001
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:10
    MESSAGE : Begin engn migration
    
    .....
    
    2011-05-23-10.30.01.423810-240 I6513E454           LEVEL: Severe
    PID     : 16464                TID  : 47407702206784PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE
    APPHDL  : 1-284                APPID: *N1.db2inst1.110523143002
    AUTHID  : db2inst1
    EDUID   : 618                  EDUNAME: db2agent (SAMPLE) 1
    FUNCTION: DB2 UDB, base sys utilities,
    sqlePrepareForSerialization, probe:30
    RETCODE : ZRC=0xFFFFEC55=-5035
    
    2011-05-23-10.30.01.424217-240 I6968E460           LEVEL: Severe
    PID     : 16464                TID  : 47407702206784PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE
    APPHDL  : 1-284                APPID: *N1.db2inst1.110523143002
    AUTHID  : db2inst1
    EDUID   : 618                  EDUNAME: db2agent (SAMPLE) 1
    FUNCTION: DB2 UDB, base sys utilities,
    sqeDBMgr::StartUsingLocalDatabase, probe:10
    
    .....
    
    2011-05-23-10.30.11.189544-240 I17291E1145         LEVEL: Error
    PID     : 19395                TID  : 47325833587008PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014          DB   : SAMPLE
    APPHDL  : 1-282                APPID: *N1.db2inst1.110523142931
    AUTHID  : db2inst1
    EDUID   : 1015                 EDUNAME: db2agntp (SAMPLE) 14
    FUNCTION: DB2 UDB, ABP, ABPIcoordAgent::spawnIcoordAgent,
    probe:200
    MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
              "SQLCA has been built and saved in component specific
    control block."
    CALLED  : DB2 UDB, base sys utilities,
    sqeIcoordCB::DispatchIndependentDBAgent
    RETCODE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
              "Maximum number of connections reached."
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -5035   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQL09073
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x0000000E
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    
    2011-05-23-10.30.11.190007-240 I18437E599          LEVEL: Severe
    PID     : 19395                TID  : 47325833587008PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014          DB   : SAMPLE
    APPHDL  : 1-282                APPID: *N1.db2inst1.110523142931
    AUTHID  : db2inst1
    EDUID   : 1015                 EDUNAME: db2agntp (SAMPLE) 14
    FUNCTION: DB2 UDB, data management, sqldMigrateOtherDMSObjects,
    probe:2097
    RETCODE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
              "Maximum number of connections reached."
    MESSAGE : Error detected at line:
    DATA #1 : unsigned integer, 8 bytes
    1930
    
    2011-05-23-10.30.11.192032-240 I19037E630          LEVEL: Severe
    PID     : 19395                TID  : 47325833587008PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014          DB   : SAMPLE
    APPHDL  : 1-282                APPID: *N1.db2inst1.110523142931
    AUTHID  : db2inst1
    EDUID   : 1015                 EDUNAME: db2agntp (SAMPLE) 14
    FUNCTION: DB2 UDB, data management, sqldMigrateTablespaces,
    probe:2610
    MESSAGE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
              "Maximum number of connections reached."
    DATA #1 : String, 27 bytes
    Error migrating tablespace!
    DATA #2 : poolID, PD_TYPE_SQLD_POOL_ID, 2 bytes
    0x0006
    
    2011-05-23-10.30.11.192194-240 I19668E11328        LEVEL: Severe
    PID     : 19395                TID  : 47325833587008PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014          DB   : SAMPLE
    APPHDL  : 1-282                APPID: *N1.db2inst1.110523142931
    AUTHID  : db2inst1
    EDUID   : 1015                 EDUNAME: db2agntp (SAMPLE) 14
    FUNCTION: DB2 UDB, data management, sqldMigrateTablespaces,
    probe:2610
    MESSAGE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
              "Maximum number of connections reached."
    DATA #1 : Pool control block, PD_TYPE_SQLB_POOL_CB, 5280 bytes
      name:                   PROC_IX
      poolID:                                  6
      flags:                                4122
      flags2:                                  0
      tflags:                                  0
      runtimeBufferPoolID:                     3
      ondiskBufferPoolID:                      3
      otblLastConsecPage:                     15
      extent_size:                            16
      prefetch_size:                          64
      page_size:                           16384
      truncThreshold:                          0
      readLatch:
    {
       state         = 0x0000000000000000
                     = {
                           held X: 0
                           reserved for X: 0
                           shared holders: 0
                           firstSharIndex: 0x0
                           firstExclIndex: 0x0
                       }
       starve X mode = false
       xWaitCount    = 0
       requestCount  = 0
       identity      = SQLB_POOL_CB::readLatch (208)
    }
      writeLatch:
    {
       state         = 0x0000000000000000
                     = {
                           held X: 0
                           reserved for X: 0
                           shared holders: 0
                           firstSharIndex: 0x0
                           firstExclIndex: 0x0
                       }
       starve X mode = false
       xWaitCount    = 0
       requestCount  = 0
       identity      = SQLB_POOL_CB::writeLatch (211)
    }
      sysTempInUseLatch:
    {
       state         = 0x0000000000000000
                     = {
                           held X: 0
                           reserved for X: 0
                           shared holders: 0
                           firstSharIndex: 0x0
                           firstExclIndex: 0x0
                       }
       starve X mode = true
       xWaitCount    = 0
       requestCount  = 0
       identity      = SQLB_POOL_CB::sysTempInUseLatch (209)
    }
      reorgPoolID:                             0
      reorgObjID:                              0
      tokenMap:               0x0000000000000000
      spillMap:               0x0000000000000000
      StateChangeObjectID:                     0
      StateChangePoolID:                       0
      version:                              8543
      pool_state:                              0
      quiesce_count:                           0
      state_id:
    
    .....
    
    2011-05-23-10.30.18.664463-240 I265498E294         LEVEL:
    Warning
    PID     : 32668                TID  : 47232692838320PROC : db2bp
    INSTANCE: db2inst1             NODE : 001
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:20
    MESSAGE : End engn migration: with rc = -1226, sqlcode = -1226
    

Local fix

  • 1. db2stop
    2. db2set DB2_DISABLE_ABP=ON
    3. db2start
    4. upgrade the database
    5. db2stop
    6. db2set DB2_DISABLE_ABP=
    7. db2start
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * UPGRADE DB fails with SQL1226N due to deferred MDC rollout   *
    * cleanup                                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fixpack 5.                        *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 Version 9.7 Fixpack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77062

  • 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

    2011-06-20

  • Closed date

    2012-01-09

  • Last modified date

    2012-01-09

  • 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 #: IC77062

Modified date: 09 January 2012