Hi,

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

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.