473,569 Members | 2,422 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Maximum size of table is 512G??

I am now using db2 v8.2 64bits without DPF. I want to create a very
large table which is about 1000G and the record length is suitable for
32K page size. I find in the manual that the maximum size for 32K page
size container is 512G only. Does it mean that the maximum size for 1
tablespace is also limited by 512G or I can create a tablespace with 2
containers (512G each) to support 1000G table? Thanks.

Jun 7 '07 #1
2 3580
On 7 Cze, 09:50, Woody Ling <woodyl...@gmai l.comwrote:
I am now using db2 v8.2 64bits without DPF. I want to create a very
large table which is about 1000G and the record length is suitable for
32K page size. I find in the manual that the maximum size for 32K page
size container is 512G only. Does it mean that the maximum size for 1
tablespace is also limited by 512G or I can create a tablespace with 2
containers (512G each) to support 1000G table? Thanks.
With version 8 the maximum size for a non partitioned tablespace is
512 G.

You have 2 options:

1. Create tablespace which spans multiple DPF partitions -- is that
case maximum size is: 512 G multiplied by number of partitions, or

2. Use version 9 and Large tablespaces (the default in version 9) --
for 32 K page the max size is 16 T

-- Artur Wronski

Jun 7 '07 #2
A 3rd option (workaround) is to partition the data on some column
easily partitionable (such as date), and then create a union all view
on top. Each of the sub-tables should be in separate tablespaces and
therefore could go over the 512GB limit.

Artur <ar***********@ gmail.comwrites :
On 7 Cze, 09:50, Woody Ling <woodyl...@gmai l.comwrote:
>I am now using db2 v8.2 64bits without DPF. I want to create a
very large table which is about 1000G and the record length is
suitable for 32K page size. I find in the manual that the
maximum size for 32K page size container is 512G only. Does it
mean that the maximum size for 1 tablespace is also limited by
512G or I can create a tablespace with 2 containers (512G each)
to support 1000G table? Thanks.

With version 8 the maximum size for a non partitioned tablespace
is 512 G.

You have 2 options:

1. Create tablespace which spans multiple DPF partitions -- is
that case maximum size is: 512 G multiplied by number of
partitions, or

2. Use version 9 and Large tablespaces (the default in version 9)
-- for 32 K page the max size is 16 T

-- Artur Wronski
--
Haider
Jun 7 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
6845
by: Joe Goh | last post by:
Hi there Does anyone know what is the maximum column length for a table in a MySQL database? I was thinking of storing feedback in the form of text in the database. How feasible is this? Would appreciate any insights or suggestions. Thank you again Joe
1
2343
by: LRW | last post by:
I'm using mySQL 4.0.20, interfacing it with phpMyAdmin 2.5.6. I usually set tables up with a "default" type, which I believe is myISAM (or whatever that one is.) But I decided to go with InnoDB for the stability and accuracy. Noticed something on tables in that format I've never noticed in the other format: tbl_product 1 InnoDB - ...
3
5004
by: Dave Crypto | last post by:
Hi There, SUMMARY: I need to know what the actual maximum date limit possible on a row of a MYSQL database. MORE DETAILS: For example, does a MYSQL database only allow 4032 bytes of data to be
18
6328
by: Jeff Boes | last post by:
I'm sure this is a concept that's been explored here. I have a table (fairly simple, just two columns, one of which is a 32-digit checksum) with several million rows (currently, about 7 million). About a million times a day we do select * from my_table where md5 = ? to verify presence or absence of the row, and base further processing on...
2
28546
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
2
2738
by: ari | last post by:
Hi! Normally Google helps a lot with these simple questions, but now I cannot get correct search words. So I try here: I have db2 udb 8.1 fix pack 6, and it is on windows 2003 server. - what is the maximum table space size? 64GB? - what is the maximum container size for tablespace?
2
2288
by: Jean Bidule | last post by:
Hi, I installed phpmyadmin to test my site on my homecomputer. The table i want to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum size is 2048 kb. Where can I change the maximum size of text files in PhpMyAdmin ? Somewhere in "config.inc.php" ? Thank you very much
4
5080
by: p.numminen | last post by:
Is it possible, with CSS, to determine a certain _maximum_ width for a text, paragraph, division, etc.?
1
4504
by: bujjus173 | last post by:
Hi All, I try to run a SQL which inserts data into a table. i get this error. SQL0659N Maximum size of a table object has been exceeded Can anyone suggest what i can do, I tried reorg, i did drop few indexes, but of no use. Is there any other way i can get rid of this. Thank you.
0
7703
marktang
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...
0
8132
jinu1996
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...
1
7678
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...
0
7982
tracyyun
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...
1
5514
isladogs
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...
0
3656
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3644
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2116
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
0
944
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.