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 6  6886 
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.
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
"Smutny30" <sm******@poczta.onet.pl> wrote in message
news:d0**********@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.
Użytkownik "Mark A" <no****@nowhere.com> napisał w wiadomo¶ci
news:2d********************@comcast.com... "Smutny30" <sm******@poczta.onet.pl> wrote in message
news:d0**********@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
Uzytkownik "Serge Rielau" <sr*****@ca.ibm.com> napisal w wiadomosci
news:39*************@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
> 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: CK |
last post by:
Need a piece of advice on allocation of tablespaces for partitioning
We are using a day level range-based approach as our parititiong
scheme given that we have data inflows running into 15...
|
by: SM |
last post by:
/*
problem: Trying to get partitioned views to "prune" unneeded
partitions from
select statements against the partitioned view. There are 5
partitioned
tables. Each with a check constraint...
|
by: dbuchanan52 |
last post by:
Hello,
I am building an application for Windows Forms using. I am new to SQL
Server 'Views'. Are the following correct understanding of their use?
1.) I believe a view can be referenced in a...
|
by: mike_dba |
last post by:
Can anyone tell me why a EEE system might be created to have two
separate tablespaces with the same 4k pagesize ? They both appear to
be in use as I can see the underlying files being modified.
...
|
by: rAinDeEr |
last post by:
Hi,
I am trying to create around 70 tablespaces for around 100 tables..
Am using DB2 UDB 8.2 in Linux environment...
This is one i generated through Control centre....
CREATE REGULAR...
|
by: dcruncher4 |
last post by:
DB2 8.2.3
the task I have is to write a script to restore a database from a
backup on to another machine.
the backup can be as old as seven years. The container layout on the
machine to be...
|
by: beena |
last post by:
All,
I'm new to the concept of automatic storage...
I'm looking at the database setup by a vendor. I see few tablespaces
showing up with automatic storage - Yes.
Tablespace ID ...
|
by: Troels Arvin |
last post by:
Hello,
I have recently run a rather large data import where the imported data i
pumped through some updatable views equipped with INSTEAD OF triggers. For
various reasons, the exact same data...
|
by: eeriehunk |
last post by:
Hi All,
Is it possible to create a partitioned index on a table which is not partitioned? If so what is such a partition called and please explain?
I have done some research on partitions and index...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| | |
