Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    31

    Unanswered: tempspace1 is full even though there is space in the Filesystem

    Hi,

    I have a database running db2 v8.2 on Windows 2003.

    Im facing tablespace full issue eventhough there is still space in the filesystem.

    Please help

    2014-01-13-05.29.48.312003 InstanceB2 Node:000
    PID:3560(db2syscs.exe) TID:12140 Appid:none
    buffer pool services sqlbClnrAsyncWriteCompletion Probe:0

    ADM6017E The table space "TEMPSPACE1" (ID "1") is full. Detected on container
    "e:\DB2\NODE0000\BODB06\T0000001\C0000000.TMP" (ID "0"). The underlying file
    system is full or the maximum allowed space usage for the file system has been
    reached. It is also possible that there are user limits in place with respect
    to maximum file size and these limits have been reached.




    2014-01-13-05.07.04.004006 InstanceB2 Node:000
    PID:18096(db2syscs.exe) TID:28296 Appid:none
    buffer pool services sqlbClnrAsyncWriteCompletion Probe:0

    ADM6017E The table space "TEMPSPACE1" (ID "1") is full. Detected on container
    "e:\DB2\NODE0000\BODB09\T0000001\C0000000.TMP" (ID "0"). The underlying file
    system is full or the maximum allowed space usage for the file system has been
    reached. It is also possible that there are user limits in place with respect
    to maximum file size and these limits have been reached.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    did you hit any Limits?
    SQL limits

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Are you sure there was enough space on the file system at the exact time that error occurred? Tempspace is only used during the duration of an SQL statement and then is immediately deleted, so it is usually hard to know the maximum file system space that was reached. As soon as that error happens, the SQL statement is ended and the tempspace used for that SQL is returned to the OS.

    The other thing mentioned is that some operating systems have a limit as to how large a single file can be created on any file system. On Linux/UNIX the default can low (especially on older systems) but this can changed at the USER level (instance owner). I don't know if there are any such limits for the Windows version you have.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jul 2013
    Posts
    31
    Thank you guys. I'll check on this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •