Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Unanswered: Drop and recreate DBTEMP tablespace

    In DB2 ver 8 on Z/OS, how to check if no one is using the DBTEM tablespace that you are going to drop and recreate ?

    There are some tools like IBM DB2 Query Monitor for z/OS but don't have it installed unfortunately . Does anyone using DB2 on z/OS has some experience
    on how to check ,without any 3ed party tools , if anyone is using the DBTEMP tablespace . There are several other DBTEMP tablespaces that will remain in RW so ... maybe not really a problem as DB2 will select a different DBTEMP tablespace that is still in status RW .

    Or isn't it a problem to issue the drop , if the DBTEMP tablespace is in use you'll get a message and the drop will not work ?

  2. #2
    Join Date
    Dec 2005
    -DIS DB(DBTEMP) SPACE(yourspace) USE

    should show whether the space is currently used.

Posting Permissions

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