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 redirect restore change
page size ? I am looking for suggestions.
thanks!
Patrick Tan
2  5407 
"Patrick Tan" <pa*********@sy mptico.ca> wrote in message
news:yh******** ************@ne ws20.bellglobal .com... 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 redirect restore change
page size ? I am looking for suggestions.
Redirect restore cannot change page size.
You have two alternatives.
1) Export the data, recreate the table with a larger page size, and import
the data
2) Investigate using the UNION ALL view approach to combine two (or more)
tables into one "virtual" table. This only works if your data is easily
partitionable. You need v8 FP4 for this as well.
--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab
Patrick Tan wrote: 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 redirect restore change
page size ? I am looking for suggestions.
You can't change a tablespace's page size during a restore. You have 2
options:
1) Unload / reload data into the table after moving it to a tablespace
with a larger page size. (Be aware of the limit of 255 rows per page)
2) Move to a partitioned environment, where the limit is 64 Gb per
partition. Of course this requies money (to buy the data partitioning
feature), as well as time (to actually partition the data).
Good luck
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: milkyway |
last post by:
Hello everyone,
I have a page that is being displayed in a browser (Microsoft IE). When
one reduces the size of the IE browser, one has a choice of the
following: maximize (gets a full-screen result), medium-sized (where
the browser window is smaller) and minimized.
I would like it so that when the browser window becomes medium-sized,
that the web page being displayed in the browser stays the same size
and does not adjust to fit into...
|
by: xixi |
last post by:
we are using db2 udb v8.1 on win 64 bit HP titanium machine with fp3
with type 4 db2jcc.jar driver.
i have two database created under different patition on same drive.
when i do db2dart on the database, i found both database have the same
index bad page error on same table. one database is the same image of
another except the tablespace redirect to different patition. the
index should be created under the same tablespace relates to its...
|
by: Steve Gallagher |
last post by:
I create my database and a number of tables from within a .bat file.
When I set the FULL_TXT field to 3800 or less, all is well. Above
3800, I get
SQL0286N A default table space could not be found with a page size of
at least "8192" that authorization ID "GALLAGS" is authorized to use.
SQLSTATE=42727
Now, I know this means that DB2 is trying to build into a tablespace
that's too small to hold a row of this total size, but I cannot...
|
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 4K tablespace from the
backup, reset back to circular logging. Would this work?
|
by: Raja Shekar |
last post by:
HI Every body ,
I would like to know whether is it mandatory to give Tablespace page
size and Bufferpool page size equal..? i also heard like while creating
tablespace if pages size of tablespace and bufferpool , the statement
itself will fail ...why i'm asking is if we chose a different page size
( ofcourse less than bufferpool page size ) only it shoud affect the
performance of db2 ..
Thanks in Advance
Raja Shekar
| | |
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: Asphalt Blazer |
last post by:
Can anybody explain to me the relation between extentsize and pagesize.
When I am creating a new tablespace what do I need to be careful of?
Say pagesize is 8K is keeping extentsize(pages) 64 too large? What
exactly is the relation?
Thanks
|
by: Konstantin Andreev |
last post by:
Hello.
I'm experiencing very disagreeable problem: DB2 refuses tablespace containers, which are DEVICE's bigger than 4G.
So, If I below 4G limit:
| # db2 create tablespace TS1 pagesize 4096 managed by database using ( device '/dev/dtas1' 1048575 )
|
| DB20000I The SQL command completed successfully.
|
by: Ultrak The DBA |
last post by:
64 bit instance:
DB21085I Instance uses "64" bits and DB2 code release "SQL08027" with
level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and
FixPak
"14".
db panic on the following error:
MESSAGE : ADM6017E The table space "BALANCE_TSD" (ID "7") is full.
Detected on
|
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: 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.
| |
