Re: Empty table, why so many space ?
This is a discussion on Re: Empty table, why so many space ? within the DB2 forums, part of the Database Server Software category; --> "MaisonBorniol" <maisonborniol@nomade.fr> wrote in message news:29f4fc84.0306260116.6aeefcb@posting.google.co m... > [Snip] > > What type of tablespace is the table located ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 09:46 AM
| ||||
| ||||
 Re: Empty table, why so many space ? "MaisonBorniol" <maisonborniol@nomade.fr> wrote in message news:29f4fc84.0306260116.6aeefcb@posting.google.co m... > [Snip] > > What type of tablespace is the table located in? If the tablespace is > > managed by the database (DMS) then the space is allocated when the > > tablespace is created. > > Yes the tablespace is managed by the DMS. Is it possible to be managed > by something else ? The minimum space allocated is 5 extents. So look at your extent size and figure out if that is correct.      |
Linear Mode
