sms tablespace: decrease Size
This is a discussion on sms tablespace: decrease Size within the DB2 forums, part of the Database Server Software category; --> Hello, a SMS Tablespace is managed by the OS. When the DB needs a page the OS allocates the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:06 PM
| ||||
| ||||
 sms tablespace: decrease Size Hello, a SMS Tablespace is managed by the OS. When the DB needs a page the OS allocates the nessesary Space for the DB. But, what happens when all rows of all tables (belonging the SMS-TS) are deleted. Deallocates the OS some Space? If Yes, at what Time? Thanks for your answers! stefan      |
|
02-26-2008, 05:06 PM
| ||||
| ||||
| Re: sms tablespace: decrease Size To give back all the space you would need to do a REORG. Stefan S. wrote: >Hello, >a SMS Tablespace is managed by the OS. When the DB needs a page the OS >allocates the nessesary Space for the DB. >But, what happens when all rows of all tables (belonging the SMS-TS) >are deleted. Deallocates the OS some Space? If Yes, at what Time? > >Thanks for your answers! > >stefan > > -- Anton Versteeg IBM Certified DB2 Specialist IBM Netherlands |
Linear Mode
