|
Problem IC76458
|
Status: Closed |
POSSIBLE ONLINE BACKUP IMAGE CORRUPTION FROM PURE SCALE ENVIRONMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
Online backup images from Pure Scale environment could be
corrupted due to a synchronization issue. Under heavy
insert/update backup could read in partial pages due to the
problem and making the image unusable. The other symptoms of
the problem
is a logical error during online backup, which will cause
database to crash. The following db2diag.log messages will
appear:
2011-05-06-15.20.57.399651-240 E9576235A3102 LEVEL:
Severe (OS)
PID : 20381722 TID : 43500 KTID :
32505951
PROC : db2sysc 0
INSTANCE: DB2INST NODE : 000 DB : DB2DB
APPHDL : 0-1490 APPID: *N0.eunicec4.110506194324
AUTHID : DB2AUTH
EDUID : 43500 EDUNAME: db2bm.42985.2 (DB2DB) 0
FUNCTION: DB2 UDB, SQO Latch Tracing,
SQLO_SLATCH_CAS64::validate, probe:10
MESSAGE :
ZRC=0x870F00FB=-2029059845=SQLO_SLATCH_ERROR_HELDX_WITH_SHARED_H
OLDERS
"shared latch found with both exclusive and shared
holders. Latch likely corrupt." |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Pure Scale *
****************************************************************
* PROBLEM DESCRIPTION: *
* Online backup images from Pure Scale environment could be *
* *
* corrupted due to a synchronization issue. Under heavy *
* *
* insert/update backup could read in partial pages due to the *
* *
* problem and thereby unusable. The other symptoms of the *
* problem *
* is a logical error during online backup, which will cause *
* *
* database to come down. The following db2diag.log messages *
* will *
* appear: *
* *
* *
* *
* 2011-05-06-15.20.57.399651-240 E9576235A3102 LEVEL: *
* *
* Severe (OS) *
* *
* PID : 20381722 TID : 43500 KTID : *
* 32505951 *
* *
* PROC : db2sysc 0 *
* *
* INSTANCE: DB2INST NODE : 000 DB : DB2DB *
* APPHDL : 0-1490 APPID: *
* *N0.eunicec4.110506194324 *
* AUTHID : DB2AUTH *
* *
* EDUID : 43500 EDUNAME: db2bm.42985.2 (DB2DB) *
* 0 *
* FUNCTION: DB2 UDB, SQO Latch Tracing, *
* *
* SQLO_SLATCH_CAS64::validate, probe:10 *
* *
* MESSAGE : *
* *
* ZRC=0x870F00FB=-2029059845=SQLO_SLATCH_ERROR_HELDX_WITH_SHARED
* OLDERS *
* *
* "shared latch found with both exclusive and shared *
* *
* holders. Latch likely corrupt." *
****************************************************************
* RECOMMENDATION: *
* Temporary workaround would be to use offline backup instead *
* of online backup. *
* *
* Upgrade to v98 fp4 for the fix of the problem. *
**************************************************************** |
| Local Fix: |
1. Use offline backup instead of online backup
2. upgrade to v98 fp4
3. contact DB2 service for other possible workaround. |
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
v98 fp4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.05.2011
29.07.2011
29.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
