Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    50

    Answered: What to do SMS Tablespace has "Total pages" = "Useable pages" = "Used pages" ?

    Sorry a newbie DB2 question.

    On Linux V97Fp11, we have a Regular SMS Tablespace (having one container) which has "Total pages" = "Useable pages" = "Used pages" = 150gb
    The FS which has this container is 250GB in size and 75GB is still free.

    So how to increase the size of this tablespace in this case?

    Stella
    Last edited by StellaZhang; 03-29-16 at 05:13.

  2. Best Answer
    Posted by db2mor

    "The tablespace will grow automatically until it fills the file system. Don't confuse with DMS or automatic-storage containers."


  3. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    The tablespace will grow automatically until it fills the file system. Don't confuse with DMS or automatic-storage containers.

Posting Permissions

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