|
Problem IC80844
|
Status: Geschlossen |
DISK FULL DURING INSERT INTO TEMPORARY TABLE RESULTS IN DB MARKED BAD |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
To hit this error you need the following:
- a user temporary tablespace created with the MANAGED BY SYSTEM
option
- a declared global temporary table defined in that tablespace
created with the ON COMMIT DELETE ROWS option (either implicitly
or explicitly)
If this problem is hit, there will be messages in the
db2diag.log indicating a disk full error (SQLO_DISK) for this
user temporary tablespace, followed by a signal handler
executing, followed by the following error:
2011-12-14-08.08.51.101318-300 I2114952A475 LEVEL: Severe
PID : 65732638 TID : 1 PROC :
db2agntp (MYDB) 2
INSTANCE: myinst NODE : 001
APPHDL : 0-583 APPID:
167.68.70.12.49534.111214123200
AUTHID : NORMADM
FUNCTION: DB2 UDB, catalog services, sqlrlRecreateIndexes,
probe:99
RETCODE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.1.0.12. *
**************************************************************** |
| Local-Fix: |
1. Use the MANAGED BY DATABASE option when creating user
temporary tablespaces
OR
2. Ensure there is sufficient storage available for the user
temporary tablespaces |
| Lösung |
The problem is first fixed in DB2 version 9.1.0.12. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.01.2012
02.08.2012
02.08.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.0.12
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.12
|
 |
