DB2 Instance can get trap during 32-bit to 64-bit
upgrade (DB2 V9.5 -> DB2 V9.7 or DB2 V9.1 -> DB2 V9.7 or DB2
V8 -> DB2 V9.7)
db2 restore db sample
SQL2519N The database was restored but the restored database
was not upgraded to the current release. Error "-1224" with
tokens "-2097151957 * * * * SEMAPHORE WAIT" is returned.
db2 upgrade db sample
SQL1224N The database manager is not able to accept new
requests, has terminated all requests in progress, or has
terminated the specified request because of an error or a forced
interrupt. SQLSTATE=55032
db2 migrate db sample
SQL1224N The database manager is not able to accept new
requests, has terminated all requests in progress, or has
terminated the specified request because of an error or a forced
interrupt. SQLSTATE=55032
db2diag.log shows error related to SQLO_NOMEM/SQLO_NOMEM_APPH
eg.
2009-07-14-19.58.38.474437-240 I904428E483 LEVEL:
Warning
PID : 8176 TID : 183328827744 PROC :
db2sysc
INSTANCE: skharche NODE : 000 DB :
SAMPLE
APPHDL : 0-10 APPID:
*LOCAL.skharche.090714235833
AUTHID : SKHARCHE
EDUID : 283 EDUNAME: db2agent (SAMPLE )
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate,
probe:4888
DATA #1 : <preformatted>
Begin migrating catalog table: SYSTABLES
2009-07-14-19.58.38.946778-240 E904912E732 LEVEL:
Warning
PID : 8176 TID : 183328827744 PROC :
db2sysc
INSTANCE: skharche NODE : 000 DB :
SAMPLE
APPHDL : 0-10 APPID:
*LOCAL.skharche.090714235833
AUTHID : SKHARCHE
EDUID : 283 EDUNAME: db2agent (SAMPLE )
FUNCTION: DB2 UDB, SQO Memory Management,
sqloMemLogPoolConditions, probe:30
DATA #1 : <preformatted>
Out of memory failure for Application Heap (APPLHEAPSZ).
Requested block size : 2415919104 bytes.
Physical heap size : 131072 bytes.
Configured heap size : 1048576 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2009-07-14-19.58.38.949835-240 I905645E873 LEVEL:
Severe
PID : 8176 TID : 183328827744 PROC :
db2sysc
INSTANCE: skharche NODE : 000 DB :
SAMPLE
APPHDL : 0-10 APPID:
*LOCAL.skharche.090714235833
AUTHID : SKHARCHE
EDUID : 283 EDUNAME: db2agent (SAMPLE )
FUNCTION: DB2 UDB, catalog migration, sqlrlmXmlrnStatsUpgrade,
probe:1917
MESSAGE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
CALLED : DB2 UDB, catalog migration, sqlrlmLogErr
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application
heap.
DATA #1 : String with size, 26 bytes
Migration DMS rc=8b0f0001
2009-07-14-19.58.38.962053-240 I906519E924 LEVEL:
Severe
PID : 8176 TID : 183328827744 PROC :
db2sysc
INSTANCE: skharche NODE : 000 DB :
SAMPLE
APPHDL : 0-10 APPID:
*LOCAL.skharche.090714235833
AUTHID : SKHARCHE
EDUID : 283 EDUNAME: db2agent (SAMPLE )
FUNCTION: DB2 UDB, catalog migration, sqlrlm_95toCobra_tablepd,
probe:1733
MESSAGE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
CALLED : DB2 UDB, catalog migration, sqlrlmLogErr
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
DATA #1 : String with size, 76 bytes
Migration DMS rc=8b0f0001: Migrate Datapart PD Failed:
SYSIBM.SYSXSROBJECTS
Provided condition :
* XML tables must exist
* XML table must have had RUNSTATS issued on it at one point
before upgrading.
If there are no statistics gathered on xml tables, then you will
not be hitting this problem for your upgrade from 32-bit to
64-bit.
Problem here is incorrect usage of structures which have been
updated in v9.7. |
