|
Problem IC89555
|
Status: Closed |
BACKUP OF DATABASE UPGRADED FROM PREVIOUS RELEASE FAILS WITH SQL1224N IN SHARED DATA CONFIGURATION |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Backup of a database upgraded from a previous release may result
in SQL1224N in a shared data environment, for example:
db2 "backup 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=00000
The DB2 diagnostic log will contain messages similar to:
2013-01-09-13.50.02.662232-300 I94533A6282 LEVEL:
Severe
PID : 58917032 TID : 19949 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-110 APPID: *N0.db2inst1.130109184950
AUTHID : DB2INST1 HOSTNAME: localhost
EDUID : 19949 EDUNAME: db2bm.30129.1 (SAMPLE) 0
FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:104
DATA #1 : String, 25 bytes
bfix detected an error -
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : String, 20 bytes
Current Descriptor =
DATA #6 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 256 bytes
Pagekey: {pool:3;obj:65534;type:14} PPNum:0
<...skipping...>
Tablespace ID =
DATA #14: Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
3
DATA #15: String, 17 bytes
Tablsepace Seed =
DATA #16: Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
23789
Sample call stack:
sqlbfix
sqlbFixPage
sqlbFindNewHighWaterMark
sqlubReadDMS
sqlubBMProcessData
The meaning of these errors is that DB2 has detected a table
space ID mismatch (expected: 3, actual 23789) while loading an
SMP page (type:14).
The problem is with page verification code enabled by default in
pureScale only, which performs additional checks of the page
validity during the backup process. The code is not handling
pages created on a previous release correctly, which results in
reading an incorrect table space ID from the read page and
storing the ID to the table space descriptor. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 10.1 FP2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Backup of a database upgraded from a previous release may *
* result *
* in SQL1224N in a shared data environment, for example: *
* *
* db2 "backup 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=00000 *
* *
* The DB2 diagnostic log will contain messages similar to: *
* *
* 2013-01-09-13.50.02.662232-300 I94533A6282 LEVEL: *
* Severe *
* PID : 58917032 TID : 19949 PROC : *
* db2sysc 0 *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-110 APPID: *
* *N0.db2inst1.130109184950 *
* AUTHID : DB2INST1 HOSTNAME: localhost *
* EDUID : 19949 EDUNAME: db2bm.30129.1 *
* (SAMPLE) 0 *
* FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:104 *
* DATA #1 : String, 25 bytes *
* bfix detected an error - *
* DATA #2 : Boolean, 1 bytes *
* true *
* DATA #3 : Boolean, 1 bytes *
* false *
* DATA #4 : Boolean, 1 bytes *
* true *
* DATA #5 : String, 20 bytes *
* Current Descriptor = *
* DATA #6 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 256 *
* bytes *
* Pagekey: {pool:3;obj:65534;type:14} PPNum:0 *
* *
* <...skipping...> *
* *
* Tablespace ID = *
* DATA #14: Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes *
* 3 *
* DATA #15: String, 17 bytes *
* Tablsepace Seed = *
* DATA #16: Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes *
* 23789 *
* *
* Sample call stack: *
* *
* sqlbfix *
* sqlbFixPage *
* sqlbFindNewHighWaterMark *
* sqlubReadDMS *
* sqlubBMProcessData *
* *
* The meaning of these errors is that DB2 has detected a table *
* space ID mismatch (expected: 3, actual 23789) while loading *
* an *
* SMP page (type:14). *
* *
* The problem is with page verification code enabled by *
* default in *
* pureScale only, which performs additional checks of the page *
* validity during the backup process. The code is not handling *
* pages created on a previous release correctly, which results *
* in *
* reading an incorrect table space ID from the read page and *
* storing the ID to the table space descriptor. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 FP3 *
**************************************************************** |
| Local Fix: |
db2set DB2_BCKP_PAGE_VERIFICATION=OFF
db2stop
db2start
<retry the backup> |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2013
03.10.2013
03.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
