SEO

#1 (**permalink**) 02-27-2008, 03:06 AM

Hello,

I consider partitioning a huge table. I am not sure wheather it is possioble
only in partitioned databases. I found somewhere in docs (
http://tinyurl.com/4oara ) that there are
(simple, segmented and partitioned) tablespaces.

What is segmented tablespace ?
Is it possible to span the the tables within multiple containers (but in
some ordered manner) with no db partitions ?

sincerely Olek

#2 (**permalink**) 02-27-2008, 03:06 AM

Hi,
If tablespace is defined with multiple container, DB2 will allocate
block in Round-Robin fashion as and when new block is need. But table
can't span multiple tablespace...

Cheers,
Thiru.
WantedToBeDBA.

#3 (**permalink**) 02-27-2008, 03:06 AM

Smutny30 wrote:
> Hello,
>
> I consider partitioning a huge table. I am not sure wheather it is possioble
> only in partitioned databases. I found somewhere in docs (
> http://tinyurl.com/4oara ) that there are
> (simple, segmented and partitioned) tablespaces.
>
> What is segmented tablespace ?
> Is it possible to span the the tables within multiple containers (but in
> some ordered manner) with no db partitions ?
>
> sincerely Olek
>
>
Oleg, define "huge" DB2 has a limit in the number of rows because the
RID is a 4 byte integer. With 32K pages this gives you up to 512 GB of data.
If you need more than that you can either use DPF or you use UNION ALL
views to do partitioning.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

#4 (**permalink**) 02-27-2008, 03:06 AM

"Smutny30" <smutny30@poczta.onet.pl> wrote in message
news:d0mnn2$mrj$1@news.onet.pl...
> Hello,
>
> I consider partitioning a huge table. I am not sure wheather it is
possioble
> only in partitioned databases. I found somewhere in docs (
> http://tinyurl.com/4oara ) that there are
> (simple, segmented and partitioned) tablespaces.
>
> What is segmented tablespace ?
> Is it possible to span the the tables within multiple containers (but in
> some ordered manner) with no db partitions ?
>
> sincerely Olek
>
Simple, segmented and partitioned tablespaces exist only in DB2 for z/OS and
OS/390.

Since you mention containers later in your post, I assume you working with
DB2 for LUW (DB2 for z/OS and OS/390 does not have containers). If that is
not correct, please clarify.

#5 (**permalink**) 02-27-2008, 03:07 AM

U¿ytkownik "Mark A" <nobody@nowhere.com> napisa³ w wiadomo¶ci
news:2dmdnSToitUah7LfRVn-uw@comcast.com...
> "Smutny30" <smutny30@poczta.onet.pl> wrote in message
> news:d0mnn2$mrj$1@news.onet.pl...
> > Hello,
> >
> > I consider partitioning a huge table. I am not sure wheather it is
> possioble
> > only in partitioned databases. I found somewhere in docs (
> > http://tinyurl.com/4oara ) that there are
> > (simple, segmented and partitioned) tablespaces.
> >
> > What is segmented tablespace ?
> > Is it possible to span the the tables within multiple containers (but in
> > some ordered manner) with no db partitions ?
> >
> > sincerely Olek
> >
> Simple, segmented and partitioned tablespaces exist only in DB2 for z/OS
and
> OS/390.

Thank you for the clarification.

>
> Since you mention containers later in your post, I assume you working with
> DB2 for LUW (DB2 for z/OS and OS/390 does not have containers). If that is
> not correct, please clarify.

I don't know what LUW stands for (Linux, Unix, Windows ?) . Yes I work on
AIX 5 L.

sincerely Olek

#6 (**permalink**) 02-27-2008, 03:07 AM

Uzytkownik "Serge Rielau" <srielau@ca.ibm.com> napisal w wiadomosci
news:398bsoF60cqugU1@individual.net...
> Smutny30 wrote:
> > Hello,
> >
> > I consider partitioning a huge table. I am not sure wheather it is
possioble
> > only in partitioned databases. I found somewhere in docs (
> > http://tinyurl.com/4oara ) that there are
> > (simple, segmented and partitioned) tablespaces.
> >
> > What is segmented tablespace ?
> > Is it possible to span the the tables within multiple containers (but in
> > some ordered manner) with no db partitions ?
> >
> > sincerely Olek
> >
> >
> Oleg, define "huge" DB2 has a limit in the number of rows because the
> RID is a 4 byte integer. With 32K pages this gives you up to 512 GB of
data.
> If you need more than that you can either use DPF or you use UNION ALL
> views to do partitioning.

Hello, I estimeted that whole database could grow 0.8 - 1.2 TB per year. But
the client wants to be able obtain reports from the whole database. The only
facilitation is that there will be no updates, just inserts and reports.

sincerely Olek

#7 (**permalink**) 02-27-2008, 03:08 AM

> I don't know what LUW stands for (Linux, Unix, Windows ?) . Yes I work on
> AIX 5 L.
>
> sincerely Olek
>
Yes, LUW is Linux, Unix, Windows.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

simple, segmented, or partitioned tablespaces