Professional Web Applications Themes

database managed space - IBM DB2

hi, i am using db2 udb v8.1 for windows 64-bit 1. i try to create a table space on raw device D, i set the size is 4000Mb, when i read help text , it says Device containers must use logical volumes with a "character special interface", not physical volumes. when does this means? 2. i create a table space named sample1 on raw device c:\ , i try to alter the container size from 6M to 5M by using the control center wizard, here is the sql i get from db2 ALTER TABLESPACE TEST RESIZE ( DEVICE '\.\\.\C::' 1280 ...

  1. #1

    Default database managed space

    hi, i am using db2 udb v8.1 for windows 64-bit

    1. i try to create a table space on raw device D, i set the size is
    4000Mb, when i read help text , it says

    Device containers must use logical volumes with a "character special
    interface", not physical volumes.

    when does this means?

    2. i create a table space named sample1 on raw device c:\ , i try to
    alter the container size from 6M to 5M by using the control center
    wizard, here is the sql i get from db2

    ALTER TABLESPACE TEST RESIZE ( DEVICE '\\.\\\.\C::' 1280 )

    what the 1280 means?

    i got the error

    SQL0298N Bad container path.
    SQLSTATE=428B2

    what it means?

    thanks
    xixi Guest

  2. #2

    Default Re: database managed space



    xixi wrote:
    > hi, i am using db2 udb v8.1 for windows 64-bit
    >
    > 1. i try to create a table space on raw device D, i set the size is
    > 4000Mb, when i read help text , it says
    >
    > Device containers must use logical volumes with a "character special
    > interface", not physical volumes.
    >
    > when does this means?
    >
    > 2. i create a table space named sample1 on raw device c:\ , i try to
    > alter the container size from 6M to 5M by using the control center
    > wizard, here is the sql i get from db2
    >
    > ALTER TABLESPACE TEST RESIZE ( DEVICE '\\.\\\.\C::' 1280 )
    ===
    (device '\\.\c:\' 1280)

    What's the extent size?
    >
    >
    > what the 1280 means?
    >
    > i got the error
    >
    > SQL0298N Bad container path.
    > SQLSTATE=428B2
    >
    > what it means?
    >
    > thanks
    Fan Ruo Xin Guest

  3. #3

    Default Re: database managed space

    xixi <dai_xi> wrote:
    > 2. i create a table space named sample1 on raw device c:\ , i try to
    > alter the container size from 6M to 5M by using the control center
    > wizard, here is the sql i get from db2
    >
    > ALTER TABLESPACE TEST RESIZE ( DEVICE '\\.\\\.\C::' 1280 )
    >
    > what the 1280 means?
    The 1280 represents the (new) number of pages for the table space. I assume
    that you have 4K pages, so 1280 x 4K is the 5M you wanted. (Have a look at
    ALTER TABLESPACE in the SQL Reference.)
    > i got the error
    >
    > SQL0298N Bad container path.
    > SQLSTATE=428B2
    The path above looks strange to me, but I don't know enough about containers
    on Windows to really comment on that.

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Stolze Guest

  4. #4

    Default Re: database managed space

    1280 is the number of pages.

    try this command db2listvolumes.exe
    then
    type tablespace.ddl
    see also volumes.xml

    This will show you approximately the same data as the windows command
    mountvol


    PM


    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. Newbie: How to add Non-breaking Space in a database field?
    By flashguru_in@yahoo.com in forum MySQL
    Replies: 2
    Last Post: March 6th, 08:24 PM
  2. Replies: 0
    Last Post: August 15th, 07:28 PM
  3. Space management for Locally managed tablespaces
    By Simon Lenn in forum Oracle Server
    Replies: 4
    Last Post: January 10th, 02:27 PM
  4. Replies: 11
    Last Post: January 9th, 07:46 PM
  5. Managed Standby Database Again
    By bgt0990 in forum Oracle Server
    Replies: 4
    Last Post: December 10th, 07:39 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