Can I partition an existing table?
I have a table which has started growing at a very fast pace and would
like to partition it.
Thanks.
Cheers,
San. 6 4127
shsandeep wrote: Can I partition an existing table? I have a table which has started growing at a very fast pace and would like to partition it.
Which platform are you talking about and which sort of partitioning?
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Db2 V8.2 on AIX V5.3
Partitioning a table based on the partitioning keys.
"shsandeep" <sa**********@g mail.com> wrote in message
news:a8******** *************** *******@localho st.talkaboutdat abases.com... Db2 V8.2 on AIX V5.3 Partitioning a table based on the partitioning keys.
You need DB2 ESE with Data Partitioning Feature, and you would have to
recreate the table.
DB2 V9 will support Range Partitioning as part of the standard offering (I
presume).
We do have DPF available.
So, will I have to create a new table using
'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the
data from the previous table?
Thanks for your help.
cheers,
San.
"shsandeep" <sa**********@g mail.com> wrote in message
news:f4******** *************** *******@localho st.talkaboutdat abases.com... We do have DPF available. So, will I have to create a new table using 'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the data from the previous table?
Thanks for your help.
cheers, San.
First you need to add database partitions, either on the same physical
machine, or on another machine (in which case you need to install DB2 on the
other machine). See the START DATABASE MANAGER and ADD DBPARTITIONNUM
command.
However, I would not try to create partitioned databases under DPF unless
you have had some training or get some consulting help, or unless you find a
very good book on the subject. DPF is not anything like range partitioning
in Oracle or DB2 for z/OS.
Mark A wrote: "shsandeep" <sa**********@g mail.com> wrote in message news:f4******** *************** *******@localho st.talkaboutdat abases.com... We do have DPF available. So, will I have to create a new table using 'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the data from the previous table?
Thanks for your help.
cheers, San.
San,
How big is your table? How wide are your rows?
With 32K pagesize you can reach 512GB on 255 rows/page on DB2 V8.2
In DB2 Viper that gets you to 16TB without even looking at any sort of
partitioning.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Amadrias |
last post by:
Hi,
In one of my current projects, I am willing to create a secure zone such as
Acronis does in its application to store some confidential information only
accessible to the current machine user.
I know that .Net doesn't provide such functionalities therefore I went on
MSDN Library and also on Google to look for any solution with no result...
I first guessed that using WMI it could be doable (System.Management
|
by: sameer_deshpande |
last post by:
Hi,
I need to create a partition table but the column on which I need to
create a partition may not have any logical ranges. So while creating
or defining partition function I can not use any range.
like
CREATE PARTITION FUNCTION my_part_func (NUMERIC(7)) AS RANGE LEFT FOR
VALUES (1,100,1000);
|
by: Laurence |
last post by:
Hi folks,
As I konw: database partition (aka data partition?), the database can
span multiple machines; table partition, the data within a table can
seperate by certain condition.
How about inter-partition and intra-partition? Is inter-partition
database partition...?
|
by: nbajrach |
last post by:
how to partition on a table if table already exits without any partition.
This is what i tried but gave me error
SQL> alter table sip add partition by range(si_id)
2 partition p1_si values less than (50001),
3 partition p2_si values less than (100001),
|
by: astrix |
last post by:
Hi,
I would like to know if it is possible to do an exchange partition between a partitioned
table on dbA and a non partitioned table on dbB using db links.
say I have a partitioned table - billing_records which is range partition - 1 partition for each month.
This table resides on database A. the partition names are jan_2007, feb_2007....
I have a db B. which has the smaller tables afor each month - billing_jan_2007, billing_feb_2007.
| |
by: Vinod Sadanandan |
last post by:
Table Partition Performance analysis
============================================
Collection of Statistics for Cost-Based Optimization/DBMS_STATS vs. ANALYZE
The cost-based approach relies on statistics and if the cost-based
Approach is used , then statistics should be gernerated for all tables, clusters, and all types of indexes accessed by SQL statements. If the size and data distribution of your tables change frequently, then...
|
by: debasisdas |
last post by:
SAMPLE CODE TO CREATE SUB PARTITIONS
=======================================
RANGE-HASH-9i
-------------------------
CREATE TABLE SUBPART
(
ID NUMBER(10) PRIMARY KEY,
NAME VARCHAR2(20)
)
|
by: debasisdas |
last post by:
USING PARTITION
===================
PARTITION BY RANGE-as per Oracle 8
--------------------------------------
CREATE TABLE RANGEPART
(
ID NUMBER(2) PRIMARY KEY,
NAME VARCHAR2(20)
)
|
by: Justin |
last post by:
Is there a way to attach a partition to an existing table that already
has partitions (without loading data)? For example, the syntax of the
attach partition is documented below:
alter table <tablenameattach partition P_data_2009Q1 STARTING FROM
('01/01/2009') INCLUSIVE ENDING AT ('03/31/2009') INCLUSIVE from
<tableload>
The goal is to set-up the partition but not actually load any data
into it.
|
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |