473,765 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 table space too big problem

Hi Folks,

I have a problem while creating a big table space. It reports error:
SQL1139N The total size of the table space is too big

Explanation: The size of the current table space is too big. The size of a REGULAR table space is limited to 0xFFFFFF (16777215) pages while the size of a TEMPORARY/LONG table space is limited to 2 tera bytes (2 TB).

User Response: Check the diagnostic log file db2diag.log for details. Reduce the size of the table space and correct the SQL statement.
The table space is REGULAR with 4KB page. And I tried to create a 67GB table space. It seems this already exceeds the size limit. I can use the 32KB buffer pool but there is still a limit which is far below my expected a few TB (while a TEMPORARY/LONG table space has a 2TB limit as well). Is this the DB2 limit? Please advice.

Thanks in advance.

Bing

Nov 12 '05
10 9911
But with max 255 rows of 20 bytes (5100) per 32k page that would waste lots
of space.
(approx.)

Additional info, reminder :
For more accurate calculations, see
http://publib.boulder.ibm.com/infoce...help/index.jsp
Space requirements for user table data

PM
"Blair Adamache" <ba*******@2muc hspam.yahoo.com > a écrit dans le message de
news:bq******** **@hanover.toro lab.ibm.com...
The maximum table size (with 32 k pages) is half a terrabyte - so a 2 TB
table (excluding LOBs/long fields) would require 4 partitions.

Bing Wu wrote:
Thanks for comments. Does this mean if I have a 2TB data table, I need
31 partitations and 31 processors to run the database?

Thanks,

Bing

Mark A wrote:

You should usually have at least 1 processor for each partition for
optimum
performance.

Nov 12 '05 #11

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

Similar topics

2
7749
by: Stephen Weatherly | last post by:
Could anyone please help me with a problem I am having with my table widths??? If I have 2 images within a td tag, but using CSS relative positioning I position one over the top of the second (I am placing a transparent gif over the top of a normal gif) then the width of my table is large enough to accommodate both images side by side My browsers (both IE ad Firefox) do not appear take into account the relative positioning of my...
7
3281
by: Richard Lawrence | last post by:
Hi, Consider the following: #Content { margin:0px 210px 50px 200px; padding:10px; } If I use it with the following HTML:
12
2157
by: Bob | last post by:
Hello Everyone, I have a series of two column tables that is causing me a problem. The space between column 1 and 2 seems to vary by a small amount from one table to the next. For example, the space between the first and second columns changes like this: Address: <space> 222 North B Street. You can see this at www.usernomics.com/ergonomic-products-keyboards.html .
1
5021
by: xixi | last post by:
There is one thing I don't understand, I have default tablespace userspace1 is database managed type, with total freepages 506048. another one called tmpxx is DMS type too, with 525120 free pages. When I create a new table (did not specify on which tablespace), why the table not created on the userspace1 but instead on tmpxx? what is the rule to create a table on tablespace without specify in which tablespace if I have both tablespace...
2
16484
by: Oliver Stratmann | last post by:
Hello All! I've got a problem with our DB2/NT 8.1.0 Database. The following SELECT on a big Table (2,5 Million rows) finishes with the Error "Unable to allocate new pages in table space "TEMPSPACE1".". Sometimes some rows are displayed. We tried all the hints of the Docs but it won't work. Can anybody give me a hint in which way this problem should be analyzed? I'm sorry ti bother You, but this is the last idea i've had.
8
3479
by: chrisoftoday | last post by:
Hi, I'm having trouble with some white space that's appearing in my table. I can't seem to spot the problem, it'd be great if someone could help. The HTML code (ignore the PHP, it shouldn't be an issue) I'm using to create the table is... <table align="center" cellpadding="5" width="650" border="1"> <tr> <td width="100">
2
7703
ramprabu
by: ramprabu | last post by:
Hello, I will give the sample code of html. Here first table only apply border 1 width. other tables are border 0. The problem is border=0 means border was not visible but it takes white border space. I want to remove this space. How can I solve? <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server">
1
1868
by: ellenraju | last post by:
When we create an object in oracle we can specify table space, if not it will take default table space, while creating global temporary table how can we specify the table space...and even if we create temp table without mentioning table space where the structure of the temp table stored and when we are trying to insert data into it which table space it will use....? I faced one problem earlier that..I can describe the table but when iam...
1
1783
oranoos3000
by: oranoos3000 | last post by:
hi I have a table with large height and inside of this large table i have only one table with small height in show small height table is shown in middle of space of large table and have blank space befor and after small table I want small table appear in top of space of large table and blank space is appear in bottom of small table inside large table what do I have to do? thanks alot
0
9568
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9404
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10008
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8833
agi2029
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...
1
7381
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6651
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();...
0
5423
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3929
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
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.