| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC75431 | Status: Closed |
IF SAVESNAPSHOT WAS RETURNED AS ERROR, TEMPORARY SNAP FILE WAS NOT DELETED. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
The snapshot table function was created temporary file.
If saveSnapshot was returned as error, temporary snap file was
not deleted.
saveSnapshot was created temporary file.
2010-06-24-20.10.09.676988+540 I592242913A380 LEVEL: Info
PID : 123456 TID : 777 PROC : db2fmp
(C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 777 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, database application extension for syste,
saveSnapshot, probe:692
DATA #1 : File name, 37 bytes
/home/db2inst1/sqllib/tmp/xxxxxxxx
2010-06-24-20.10.14.085439+540 I592243613A1472 LEVEL: Error
(OS)
PID : 123456 TID : 777 PROC : db2fmp
(C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 777 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 Common, OSSe, OSSHFile::write, probe:40
MESSAGE : ECF=0x90000028=-1879048152=ECF_FILE_NO_SPACE
No free space on the file system
CALLED : OS, -, write
OSERR : ENOSPC (28) "No space left on device"
... snip ...
Created temporary file was not deleted, after snapshot table
function was finished.
$ ls /home/db2inst1/sqllib/tmp
xxxxxxxx | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: * * Upgrade server to v9.5 Fixpack 8 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in v9.5 Fixpack 8. At minimum this fix should be applied to the server. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.03.2011 27.06.2011 27.06.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.5.0.8 |
|