Ask a Question related to IBM DB2, Design and Development.

  1. #1

    Default create table space

    i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can
    create DMS to achieve high performance, to add the container, i can do
    file or device, which is preferable?

    after i create a DMS table space on raw device, i want to alter it by
    altering the container size ( from 4000 mb to 5000 mb), but get bad
    container error? why is that?
    xixi Guest

  2. Similar Questions and Discussions

    1. how to create a Indexed color space
      Hi, I am trying to create any "Indexed" colorspace but I always fail. This is the simplest code I've tried PDEIndexedColorData* csData = new...
    2. table space impact on query optimization
      Hi, based on the doc, ther are two characteristics which is overhead and transferrate have impact on the I/O cose duing query execution. Since i...
    3. alter a DMS table space
      hello, i am using db2 udb v8.1 on windows, i am using DMS for table data, i need to increase the size for the table space, is this the right...
    4. Empty table, why so many space ?
      "MaisonBorniol" <maisonborniol@nomade.fr> wrote in message news:29f4fc84.0306260116.6aeefcb@posting.google.com... The minimum space allocated is...
    5. script for table extent space used
      "Howard J. Rogers" <howardjr2000@yahoo.com.au> wrote in message news:_%SL9.5485$jM5.15508@newsfeeds.bigpond.com... < Big Juicy Snip> the Hi...
  3. #2

    Default Re: create table space

    If you're going to use DMS for performance reasons, go with raw. For
    more info on raw versus cooked, see:

    [url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/adamache/0621_adamache.html[/url]

    Basically, if you use DMS with files, you're getting the worst of both
    worlds: the performance of the file system with the administrative
    overhead of DMS table spaces.

    xixi wrote:
    > i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can
    > create DMS to achieve high performance, to add the container, i can do
    > file or device, which is preferable?
    >
    > after i create a DMS table space on raw device, i want to alter it by
    > altering the container size ( from 4000 mb to 5000 mb), but get bad
    > container error? why is that?
    Blair Adamache Guest

  4. #3

    Default Re: create table space

    hi,

    my admin told me he has converted the physical device to a volume, so
    if i create a DMS using raw device , then if i want to backup and
    restore in other windows platform machine without volume drive, will
    the restore still works? thanks
    xixi Guest

  5. #4

    Default Re: create table space

    You can use a redirected restore to restore on another machine with
    different container paths. As long as you supply some suitably large
    DMS containers, that could mean a different volumes, or even a DMS file.

    Hope that helps.
    kdr


    xixi wrote:
    > my admin told me he has converted the physical device to a volume, so
    > if i create a DMS using raw device , then if i want to backup and
    > restore in other windows platform machine without volume drive, will
    > the restore still works? thanks
    --
    ------------------------------------------------------------------
    Kelly D. Rodger IBM Canada
    DB2 UDB Backup and Recovery Toronto Lab
    ------------------------------------------------------------------

    Kelly D. Rodger Guest

  6. #5

    Question create forum and blog in DB2 ?

    Can any one tell me:-
    How to create forum and blog in DB2 using other software like websphere Portal, Websphere server application,Tivoli Directory server,etc ?
    DONIKAPATEL Guest

Posting Permissions

  • You may not post new threads
  • You may 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