Suppose I have a table like this:
CREATE TABLE (
ITEMA CHAR(10) NOT NULL,
ITEMB VARCHAR(4000),
ITEMC VARCHAR(4000),
PRIMARY KEY (ITEMA)...
In setting up this table, I know that either ITEMB or ITEMC will have
data, but not both. (IE, the row (with overhead) will never, in fact,
be longer than 4096.) Would I put the table in a tablespace with a 4k
pagesize, or an 8k pagesize, or does it matter?
Stan 1 2497
You'll have to use an 8k tablespace.
Stanley Sinclair wrote: Suppose I have a table like this:
CREATE TABLE ( ITEMA CHAR(10) NOT NULL, ITEMB VARCHAR(4000), ITEMC VARCHAR(4000), PRIMARY KEY (ITEMA)...
In setting up this table, I know that either ITEMB or ITEMC will have data, but not both. (IE, the row (with overhead) will never, in fact, be longer than 4096.) Would I put the table in a tablespace with a 4k pagesize, or an 8k pagesize, or does it matter?
Stan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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....
|
by: Bing Wu |
last post by:
I have a user defined tablespace:
Tablespace ID = 4
Name = DATASPACE
Type = Database managed space...
|
by: Patrick Tan |
last post by:
I have a tablespace which is approaching 64 GB (for a single table), i
understand that for 4k page sized tablespaces, this is sized tablespace,
what's the best way / fastest way to do it ? can...
|
by: Nigel Robbins |
last post by:
Hi There,
I get SQL0670N when altering a table to add an extra colum.
Can an SMS tablespace be changed to have a larger page size ?
Many thanks,
Nigel Robbins
|
by: mairhtin o'feannag |
last post by:
Hello,
I have a tablespace striped across three drives, call them 1,2,3, just to
be clever. :) I allocated a lot more space (DMS) than I should have,
since I didn't know a way to estimate the...
| |
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.
|
by: hikums |
last post by:
How to accomplish a tablespace move from 32K to 4K page size on AIX
5.2, DB2 UDB 8.2?
Enable forward recovery, take 32K tablespace backup, drop 32K
tablespace, create 4K tablespace, restore to...
|
by: Alvin SIU |
last post by:
Hi all,
I am now doing development using DB2.
Q1.
There is one tablespace to store 5 tables.
But, when in production, there will be one tablespace for EACH of the
tables.
|
by: Michel Esber |
last post by:
Hi all,
DB2 LUW v8 FP15
Is there any performance overhead if a table is created on data and
index tablespaces with different page sizes ?
What kind of penalty is expected ?
Sample Layout:
|
by: deshaipet |
last post by:
Hi friends -
I created a automatic storage tablespace with a pagesize of 16 K and initial size of 64 MB.
create large tablespace test_tbsp1 pagesize 16k managed by automatic storage autoresize...
|
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,...
| |
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...
|
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...
|
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...
|
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 ...
| |
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...
| |