Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    33

    Unanswered: TEMPSPACE1 is full

    DB2 9.7.7. We have an issue of TEMPSPACE1 full while doing some third party software upgrade. I also see a diskfull error based on the db2diag error msg. In this situation, is the only option to increase the filesystem /home space?

    UNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:0
    MESSAGE : ADM6017E The table space "TEMPSPACE1" (ID "1") is full. Detected on
    container
    "/home/DB21/DB21/NODE0000/MYDB/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.

    File System Information of the target file :
    Block size = 4096 bytes
    Total size = 5969865216 bytes
    Free size = 0 bytes
    Total # of inodes = 1277952
    FS name = /dev/VolG00/LogV03
    Mount point = /home

    ulimit -a
    file size (blocks, -f) unlimited

    Log file size (4KB) (LOGFILSIZ) = 2000
    Number of primary log files (LOGPRIMARY) = 40
    Number of secondary log files (LOGSECOND) = 100
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /mydb_logs/NODE0000/

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Manidba49 View Post
    is the only option to increase the filesystem /home space?
    No. You could also create a new system temporary tablespace on a larger file system. You could also determine why the upgrade process requires that much temp space and see if you could do something to avoid that.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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