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 6908
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******@poczt a.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******** ************@co mcast.com... "Smutny30" <sm******@poczt a.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******** *****@individua l.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 million rows
each day averaging around 2GB. The table has 31 partitions (one for
each day) as we do not plan on retaining the data beyond 2/3 weeks.
The partitions are purged at the end of 2/3rd week depending upon the
when it is scheduled to run and...
|
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 based on a range of formula_id
column.
Test: Run this script to create the 5 partitioned tables and the
partitioned view. Then
|
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 stored procedure something
like this;
Select * from View1
Is that true?
|
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.
These were created with SMS and reside on the same disk and filesystem
(separate directory on filesystem). One is called temp_4k and the
other temp_sys. I would assume that the temp_sys was intended for use
by the db2 catalog. I know of no way...
|
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 TABLESPACE SNCI001 IN DATABASE PARTITION GROUP
IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM
USING ('/db2home/db2inst1/dnci1d/user_tblspace')
| |
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 restored
can be totally different from the machine which was backedup. So we are
going with redirect
restore.
|
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 = 0
Name = SYSCATSPACE
Type = Database managed space
Tablespace ID = 1
Name = TEMPSPACE1
|
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 where imported into the exact same
table/view/trigger structures (but with slightly different tablespace
configuration, see later). The involved hardware was different (one
running on x86_64, one running on PPC), but with comparable CPU, memory
and...
|
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 partitions and this is where I hit the wall the 2nd time. As per my study there are 3 types of indexed partitions: Global index (which is on an entire partitioned table) then there is Local Index (on just the partition of the table) and then there...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |