|
Problem IC80844
|
Status: Closed |
DISK FULL DURING INSERT INTO TEMPORARY TABLE RESULTS IN DB MARKED BAD |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
The problem is first fixed in DB2 version 9.1.0.12. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.01.2012
02.08.2012
02.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.0.12
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.12
|
 |
