SMS tablespace limits

[Asphalt Blazer]

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?

[m]

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.

[Mark A]

"Asphalt Blazer" <as***********@gmail.comwrote in message
news:27**********************************@t54g2000 hsg.googlegroups.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.

[Joachim Klassen]

On 26 Mrz., 22:06, m <[e-mail]:

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