View Single Post

   
  #5 (permalink)  
Old 02-27-2008, 03:07 AM
Smutny30
 
Posts: n/a
Default Re: simple, segmented, or partitioned tablespaces


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


Reply With Quote