Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    272

    Unanswered: systooltempspace full

    Environment DB2 LUW V9.5 FP10 - single partitioned environment

    SYSTOOLTEMPSPACE tablespace was full in our database. This caused many of the application jobs to fail. Can I please know why is this systooltempspace used and how could this being full possibly have affected our application jobs to fail ?


    Any help in this regards would be greatly appreciated.

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Hmm, you could always look in the doco
    http://www-01.ibm.com/support/knowle...3.html?lang=en
    A temporary tablespace is only limited by the disk space in which it resides presuming that you have created it as automatic storage (well it is in 10.5 anyway). Did it fill the disk space? What was the actual error code?
    By the way, 9.5 is out of support
    Last edited by tafster; 08-11-15 at 01:18.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Try to check the following counters to understand which statements in the packages cache mostly use the system termporary tablespace.
    SYSIBMADM.SNAPDYN_SQL.pool_temp_[data|index]_p_reads
    if you have the DFT_MON_STMT and DFT_MON_BUFPOOL dbm parameters turned ON, of course...
    Regards,
    Mark.

  4. #4
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Mark, he referred to the SYSTOOLSTMPSPACE which is a user temporary tablespace not a system temporary tablespace. It shouldn't be filling unless there is a lot of data being processed as per below

    The SYSTOOLSTMPSPACE table space is a user temporary table space used by the REORGCHK_TB_STATS, REORGCHK_IX_STATS and the ADMIN_CMD procedures for storing temporary data.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

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