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 |
