Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Is there a limit in table space size? What is maximum table space size?

    Hi,
    Is there a limit in table space size for SMS and DMS tablespaces?
    What is maximum table space size in bytes?

    My system:
    db2 Enterprice server edition 8.2 fp9 on Win2003server

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    See the SQL Limits in Appendix A of the SQL Reference Vol 1. Basically it depends on page size of the tablespace.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Yes

    As I recall its approximately 16,5 million pages

    Ergo yielding max storage of:

    Approx. 528 GB for 32 Kb tablespaces

    to

    Approx. 66 GB for 4 Kb tablespaces
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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