DB2 - Problembeschreibung
Problem IC89555 | Status: Geschlossen |
BACKUP OF DATABASE UPGRADED FROM PREVIOUS RELEASE FAILS WITH SQL1224N IN SHARED DATA CONFIGURATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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> | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.01.2013 03.10.2013 03.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 |
![]() |
10.1.0.3 |
![]() |