Professional Web Applications Themes

Empty table, why so many space ? - IBM DB2

"MaisonBorniol" <maisonborniolnomade.fr> wrote in message news:29f4fc84.0306260116.6aeefcbposting.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....

  1. #1

    Default Re: Empty table, why so many space ?

    "MaisonBorniol" <maisonborniolnomade.fr> wrote in message
    news:29f4fc84.0306260116.6aeefcbposting.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.


    Mark A Guest

  2. #2

    Default Re: Empty table, why so many space ?

    Well, it could be system managed (SMS).

    MaisonBorniol wrote:
    > [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 ?
    Blair Kenneth Adamache Guest

Similar Threads

  1. #39204 [NEW]: MsSq_Fetch_* return Empty (Var)Char as single space
    By bertrand dot lepoittevin at groupe-mma dot fr in forum PHP Bugs
    Replies: 2
    Last Post: October 20th, 08:59 AM
  2. * CSV to HTML * zero reads as empty space
    By Gregg O'Donnell in forum PERL Beginners
    Replies: 7
    Last Post: February 6th, 04:08 PM
  3. Replies: 0
    Last Post: November 19th, 02:44 PM
  4. #26315 [NEW]: mssql_fectch_* functions are returning a space char on empty fields
    By webmaster at cbre dot fr in forum PHP Development
    Replies: 0
    Last Post: November 19th, 12:22 PM
  5. Replies: 7
    Last Post: July 18th, 09:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139