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? 6 3681 hi****@gmail.co m wrote: 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?
No, you can't change page size. You have to export data, save DDL,
drop/create tablespaces, recreate objects, load data.
Why would you "reset back to circular logging"? Don't you need recovery? If
not, why not just drop everything and start from scratch?
Export, drop, create, load. Implement proper logging and log archiving.
<hi****@gmail.c om> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . 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? hi****@gmail.co m wrote: How to accomplish a tablespace move from 32K to 4K page size on AIX 5.2, DB2 UDB 8.2?
Create a new table with the same structure in the 4K tablespace, copy the
data, drop the old table and rename the new one.
Assuming you want to change table T:
CREATE TABLE T_new LIKE T
INSERT INTO T_new SELECT * FROM T
DROP TABLE T
RENAME TABLE T_new TO T
You will also have to take care of indexes and constraints like
primary/foreign keys.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
We do a lot of full replace loads in batch, recovery logging forces the
tables to load or backup pending(forgot which one). I think I can
specify "COPY NO" or "NON RECOVERABLE" to avoid this, but we have'nt
taken that route yet. Please confirm that these will get rid of that
"load or backup pending" issue.
Thanks for your tips!! hi****@gmail.co m wrote: We do a lot of full replace loads in batch, recovery logging forces the tables to load or backup pending(forgot which one). I think I can specify "COPY NO" or "NON RECOVERABLE" to avoid this, but we have'nt taken that route yet. Please confirm that these will get rid of that "load or backup pending" issue.
NONRECOVERABLE will prevent DB2 from putting the tablespace in backup
pending, but of course you won't be able to roll forward through the
load operation.
no more since Version 8. (online load)
<hi****@gmail.c om> schrieb im Newsbeitrag
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . We do a lot of full replace loads in batch, recovery logging forces the tables to load or backup pending(forgot which one). I think I can specify "COPY NO" or "NON RECOVERABLE" to avoid this, but we have'nt taken that route yet. Please confirm that these will get rid of that "load or backup pending" issue.
Thanks for your tips!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: sandeep G |
last post by:
I've a table which has a number & a blob column, both of which are NOT
NULL type. This table is composite partitioned using range & hash on
the same column.
Each partition is sub partitioned into two.
Now if I try to move the partitions to a different tablespace I get an
oracle error sayiing that ERROR: ORA_14257 cannot move partition other...
|
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...
|
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 redirect restore change
page size ? I am looking for suggestions.
thanks!
Patrick Tan
|
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 space required (long story, but
the original space was in one huge tablespace for all tables ((35 million
row tables)) and I needed to segregate...
|
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: Bruce Pullen |
last post by:
db27.2 (fp13) on AIX 5.2.
The following error is generated when attempting a reorg or, more
precisely, when the file associated with the reorg tablespace reaches
1Gb.
SQL2216N SQL error "-968" occurred while reorganizing a database
table.
I can happily export to a file > 1Gb as the same userid (who created
|
by: Pablo |
last post by:
I have observed a significant discrepancy between the amount of space
used in a long tablespace when using import as compared to load.
Can anyone explain the following?
In an attempt to move data from one table/tablepace to another observed
the following:
Exported lobfile = 291 MB (average 60K / CLOB object)
|
by: db2dude |
last post by:
Hello all,
I have a database around 600GB and all tables were self-created by the
application. Hence, we have only one huge SMS tablespace where all the
tables are stored. To get better performance, we are planning to move
the tables to a DMS tablespace with multiple containers. There are LOTS
of tables and some tables have almost 40GB of...
|
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: 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...
|
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. ...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |