Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005

    Unanswered: Increase space in tablespace


    DB: DB2 V9
    OS: Unix [AIX, Solaris, Win NT]

    Can anyone please let me know the following?

    Need to increase the space in the tablespace.
    To identify the current space

    db2 list tablespaces show detail
    db2 list tablespace for containers <number> show detail

    shall list the free/ and used pages.

    to increase
    db2 alter tablespace <tablespace name> extend (file 'file.dbf' <no. of pages>)

    How do i identify the size to be increased? I mean say there are free pages of 6MB. How do i identify how much size has to be increased based on the rows to be inserted? [say if i want to insert 100,000 rows]

    And also to know what parameters need to be considered before increasing the tablespace?

    Can anyone give me a lead?
    thanks for your input.
    -Mane SG

  2. #2
    Join Date
    Jun 2006


    It is difficult to say, how much a tablespace will increase or need.
    You should monitor the growth of these tables over time and monitor usage %
    make an estimate and see how much free space you can effort.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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