Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.