DATABASECAPACITY and SMS tablespaces

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • daiesy.ember@gmail.com
    #1

    DATABASECAPACITY and SMS tablespaces

    So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh ,
    I know). I'm tight on space and keeping an eye using the
    get_dbsize_info function - but the DATABASECAPACIT Y value keeps
    changing. I know on DMS tablespaces, DATABASECAPACIT Y is tied to the
    amount of space allocated to the tablespaces - What determines the
    value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
    it matters.

    Thanks,
    Ember
    IBM Certified Advanced Database Administrator
    DB2 UDB V8.1 for LUW
    Tags: None
    • stefan.albert
      #2
      Re: DATABASECAPACIT Y and SMS tablespaces

      We also have SMS-only DBs (and are quite happy with it. Bad experience
      with DMS!)

      DATABASECAPACIT Y is -1 for us, because the DB can't derive the total
      disk capacity.
      You have to use unix/linux tools (e.g. "df") to get this information.


      On Oct 23, 4:30 pm, daiesy.em...@gm ail.com wrote:
      So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh ,
      I know). I'm tight on space and keeping an eye using the
      get_dbsize_info function - but the DATABASECAPACIT Y value keeps
      changing. I know on DMS tablespaces, DATABASECAPACIT Y is tied to the
      amount of space allocated to the tablespaces - What determines the
      value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
      it matters.
      >
      Thanks,
      Ember
      IBM Certified Advanced Database Administrator
      DB2 UDB V8.1 for LUW

        Comment

        • Pierre StJ
          #3
          Re: DATABASECAPACIT Y and SMS tablespaces

          The size of SMS tablespace is whatever size the tables in their files
          in their container directories occupy. It will change constantly as
          the actual size of the files change in the file systems holding the
          containers.
          For DMA the size is determined by the amount of preallocated space of
          the containers. Even if empty thay will still reflect the defined size
          as their size.
          If you need to find the size of SMS based tbspaces then you have to
          use os commands to find the space occupied in the file systems holding
          your containers. Take into account the space used by lobs in their
          files or tbspaces.
          Regards, Pierre.

          On Oct 23, 10:30 am, daiesy.em...@gm ail.com wrote:
          So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh ,
          I know). I'm tight on space and keeping an eye using the
          get_dbsize_info function - but the DATABASECAPACIT Y value keeps
          changing. I know on DMS tablespaces, DATABASECAPACIT Y is tied to the
          amount of space allocated to the tablespaces - What determines the
          value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
          it matters.
          >
          Thanks,
          Ember
          IBM Certified Advanced Database Administrator
          DB2 UDB V8.1 for LUW

            Comment

            Previous template Next
            Working...