|
Problem IC84549
|
Status: Geschlossen |
TIMING CONDITIONS LEAD TO SQL0901N ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION DETACH |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
There are timing conditions which could lead to SQL0901N
ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION
DETACH. This symptom is similar to APAR IC71664. But it is
caused by timing conditions not yet addressed by that APAR fix.
Both db2pd and db2 list utilities show ASYNCHRONOUS PARTITION
DETACH is performing "Finalize detach for partition ...". In the
db2diag.log, the -901 reported for the asynchronous detach
process may appear similar to the entry below.
2012-02-13-09.17.05.210933-480 I4180806A876 LEVEL: Severe
PID : 4456546 TID : 14281 PROC : db2sysc
0
INSTANCE: dwd01 NODE : 000 DB : DWD01
APPHDL : 0-22322 APPID: *N0.DB2.120311163320
AUTHID : DWD01
EDUID : 14281 EDUNAME: db2taskp (DWD01) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 60
sqlerrmc: A hard invalidation is already taking place for this
object!
sqlerrp : SQLRA0B5
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFFEC (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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 |
First fixed in Version 10.1 Fix Pack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.06.2012
06.08.2013
06.08.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
