Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: DB2 Control Center

    Hi,
    I am using DB2 control center. In the health center messages, I am getting messages for the following:
    1. SYSCATSPACE
    2. SYSTOOLSPACE
    3. SYSTOOLSTMPSACE
    4. TEMPSPACE1
    5. USERSPACE1

    The message says that : 97% utilization.
    I am loading the tables with large number of rows and it shows 97% utilization for the above mentioned points.

    How do we alter space for them?

    Thanks,
    Saurabh.

  2. #2
    Join Date
    Jan 2006
    Posts
    6
    it seems that your table space is getting full .u could alter the tablespace

    iam sending you a sample command

    alter tablespace data01_ts resize (all 38400);

  3. #3
    Join Date
    Oct 2005
    Posts
    109
    Well, if they are SMS tablespaces then there is nothing to worry I think ...
    in default installations they are SMS.They increase/decrease as needed.

    I do not know health center, is it possible you run out of disk space ?
    Juliane

Posting Permissions

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