SMS tablespace limits

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Asphalt Blazer
    #1

    SMS tablespace limits

    I am aware in DB2 v8 there is a limit on tablespace size depending on
    pagesize; for e.g 4 K pages grow a maximum of 64 G. Does such a limit
    exist for SMS tablespaces or is addressing of rows managed by the
    Operating System and hence the limit is the maximum filesize on the
    operating system?
    Tags: None
    • m
      #2
      Re: SMS tablespace limits

      Asphalt Blazer wrote:
      I am aware in DB2 v8 there is a limit on tablespace size depending on
      pagesize; for e.g 4 K pages grow a maximum of 64 G. Does such a limit
      exist for SMS tablespaces or is addressing of rows managed by the
      Operating System and hence the limit is the maximum filesize on the
      operating system?
      Same size limits apply to tablespaces regardless of how they are managed.

        Comment

        • Mark A
          #3
          Re: SMS tablespace limits

          "Asphalt Blazer" <asphaltblazer@ gmail.comwrote in message
          news:27173116-0eff-4fe3-9526-d480a8f8fbac@t5 4g2000hsg.googl egroups.com...
          >I am aware in DB2 v8 there is a limit on tablespace size depending on
          pagesize; for e.g 4 K pages grow a maximum of 64 G. Does such a limit
          exist for SMS tablespaces or is addressing of rows managed by the
          Operating System and hence the limit is the maximum filesize on the
          operating system?
          The rows are managed by DB2, not by the OS. It is a DB2 limit.


            Comment

            • Joachim Klassen
              #4
              Re: SMS tablespace limits

              On 26 Mrz., 22:06, m <mdlspo...@yaho o.comwrote:
              Asphalt Blazer wrote:
              I am aware in DB2 v8 there is a limit on tablespace size depending on
              pagesize; for e.g 4 K pages grow a maximum of 64 G. Does such a limit
              exist for SMS tablespaces or is addressing of rows managed by the
              Operating System and hence the limit is the maximum filesize on the
              operating system?
              >
              Same size limits apply to tablespaces regardless of how they are managed.
              Not exactly - the 64 GB limit (4 K Pages) is on a per table basis in a
              SMS tablespace (max. 16.777.216 adressable Pages per table). So a SMS
              tablespace as whole can grow beyond 64 GB - but each table is limited
              to 64 GB (even in DB2 9) - whereas with DMS in DB2 V8 you are limited
              to 64 GB for the whole tablespace (DB2 9 lifts these limits to 2 TB
              and more).

              Joachim

                Comment

                Previous template Next
                Working...