Professional Web Applications Themes

used space for DMS - IBM DB2

On Mon, 04 Aug 2003 13:44:11 -0700, xixi wrote: > hi, i am using DMS for userspace1 for the first time, the database is > db2 udb v8.1 on windows. I try to right click the volume properties > where i created the container to find out the used space, but it > doesn't show it. why? is there other way i can find out what is the > actual space has been used for all the tables/indexes/views created? You can use the command - db2 "LIST TABLESPACES SHOW DETAIL" and process the results for the tablespaces. Or you can ...

  1. #1

    Default Re: used space for DMS

    On Mon, 04 Aug 2003 13:44:11 -0700, xixi wrote:
    > hi, i am using DMS for userspace1 for the first time, the database is
    > db2 udb v8.1 on windows. I try to right click the volume properties
    > where i created the container to find out the used space, but it
    > doesn't show it. why? is there other way i can find out what is the
    > actual space has been used for all the tables/indexes/views created?
    You can use the command -

    db2 "LIST TABLESPACES SHOW DETAIL"

    and process the results for the tablespaces.

    Or you can grab a Perl script I wrote to to check and resize DMS
    tablespaces when required. You'll find it at -

    [url]http://www.db-hq.net[/url]

    It's script UAS030 under section DB2 for LUW / Admin Scripts

    HTH

    Phil Nelson
    ScotDB Limited
    Philip Nelson Guest

  2. #2

    Default Re: used space for DMS

    hello Philip,

    thanks for the script, but i can't see the db2 resize DMS command
    provided on the script, can you tell me is this right command? i want
    to resize a DMS from 5G to 10G. there is data on the userspace already
    (which is 4.5 G). And E is the volume name. Will this have bad effect
    on the data after i resize? thanks

    ALTER TABLESPACE USERSPACE1 RESIZE ( DEVICE '\\.\E:' 2560000 );
    xixi Guest

Similar Threads

  1. Too Much Space in an Accordion
    By Rich Morey in forum Coldfusion Flash Integration
    Replies: 1
    Last Post: August 17th, 06:33 PM
  2. Space in 100% Width
    By Pam12345 in forum Macromedia Dynamic HTML
    Replies: 5
    Last Post: August 23rd, 03:46 PM
  3. Deleting space
    By Basmah in forum Macromedia Dynamic HTML
    Replies: 4
    Last Post: June 20th, 09:50 PM
  4. web space size?
    By T&G Chamberlain in forum Web Design
    Replies: 1
    Last Post: August 9th, 01:47 AM
  5. URL With a Space
    By Wayne Wengert in forum ASP
    Replies: 6
    Last Post: September 18th, 06:36 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