Professional Web Applications Themes

Informix & raw partitions - Informix

On Tue, 15 Jul 2003 08:58:05 -0400, "Seweryn" <pietruszewskiatt.com> wrote: >I'm new to Informix and entire db world, so please hang with me while I >explain: > Glad to have you aboard . . . >I have Solaris 8 running with one 14GB raw partition for Informix data. >I'm running Informix Dynamic Server 7.31 >Installation of IDS have created rootdbs chunk on that partition for about >600MB > >Can I create multiple dbspaces on single raw partition? Yes. >When I tried to >create dbspace message appeared saying 'Chunk already exist'. >Can I add multiple chunks to one raw partition? > ...

  1. #1

    Default Re: Informix & raw partitions

    On Tue, 15 Jul 2003 08:58:05 -0400, "Seweryn" <pietruszewskiatt.com>
    wrote:
    >I'm new to Informix and entire db world, so please hang with me while I
    >explain:
    >
    Glad to have you aboard . . .
    >I have Solaris 8 running with one 14GB raw partition for Informix data.
    >I'm running Informix Dynamic Server 7.31
    >Installation of IDS have created rootdbs chunk on that partition for about
    >600MB
    >
    >Can I create multiple dbspaces on single raw partition?
    Yes.
    >When I tried to
    >create dbspace message appeared saying 'Chunk already exist'.
    >Can I add multiple chunks to one raw partition?
    >
    Yes, again, as long as that space isn't already allocated. I'm
    assuming that you have only one Informix instance on this server . . .
    ..
    >What would be an optimal solution to place databases.
    >We have an old system that have multiple partitions and each partition is
    >considered a single chunk (about 2GB each). Is this the proper way to go or
    >was that done due to small disks.
    Are these rawspaces? 2GB is the maximum size for a chunk under your
    version.
    >
    >Can someone answer those questions and/or point me to some references that I
    >can find the answer myself.
    >Many thanks in advance.
    No problem.
    John Carlson Guest

  2. #2

    Default Re: Informix & raw partitions

    Seweryn wrote:
    > I'm new to Informix and entire db world, so please hang with me while I
    > explain:
    >
    > I have Solaris 8 running with one 14GB raw partition for Informix data.
    > I'm running Informix Dynamic Server 7.31
    > Installation of IDS have created rootdbs chunk on that partition for about
    > 600MB
    >
    > Can I create multiple dbspaces on single raw partition? When I tried to
    > create dbspace message appeared saying 'Chunk already exist'.
    > Can I add multiple chunks to one raw partition?
    >
    > What would be an optimal solution to place databases.
    > We have an old system that have multiple partitions and each partition is
    > considered a single chunk (about 2GB each). Is this the proper way to go or
    > was that done due to small disks.
    >
    > Can someone answer those questions and/or point me to some references that I
    > can find the answer myself.
    > Many thanks in advance.
    >
    As John and Paul indicated, with IDS 7.31, you are limited to creating
    chunks such that the start offset is up to 2GB, the maximum size is
    2GB, and the sum of the offset and size is 2GB. The old system, of
    necessity, used lots of small (2GB) chunks.

    If you were to upgrade to IDS 9.40.UC2 (or 9.40.UC1, I suppose, but
    why upgrade to a back version), then you would be able to use chunks
    bigger than 2GB, with offsets bigger than 2GB. Then you could create
    one or two chunks in your 14GB partition.

    --
    Jonathan Leffler #include <disclaimer.h>
    Email: [email]jlefflerearthlink.net[/email], [email]jlefflerus.ibm.com[/email]
    Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

    Jonathan Leffler Guest

Similar Threads

  1. Replies: 5
    Last Post: April 1st, 12:00 AM
  2. Replies: 0
    Last Post: October 1st, 06:15 PM
  3. From Two Partitions to One
    By Vincent Nadon in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 12th, 05:22 PM
  4. Difference between Informix connect and Informix Client SDK
    By Francisco Roldan in forum Informix
    Replies: 3
    Last Post: July 9th, 03:00 AM
  5. Replies: 1
    Last Post: June 27th, 05:04 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