Thread: Increase space in tablespace
01-17-07, 21:54 #1Registered User
- 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.
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.
01-18-07, 03:46 #2Registered User
- 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