SMS tablespace limits

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asphalt Blazer - 26 Mar 2008 16:05 GMT

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?

Reply to this Message

m - 26 Mar 2008 21:06 GMT

> 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.

Reply to this Message

Joachim Klassen - 31 Mar 2008 09:42 GMT

> > 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
[quoted text clipped - 3 lines]
>
> 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

Reply to this Message

Mark A - 26 Mar 2008 23:58 GMT

>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.

Reply to this Message