home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList
10.1.0.3 FixList