hi gurus, now I have to backup and restore a 8 T size db2 database. from two
s85 to two 670. the partitions,tabl espaces of the db should be redesigned
then I plan to use redirected restore.
but my concern is, such big size db, I'm afraid something unexpected will
destory all the effort. Who have related experience? Can you give some
advice? Thanks in advance:) 4 3812
oh, why no one reply to me? 55~~
"Hardy" <We***********@ ibm.com> дÈëÓʼþ news:cf******** ***@mail.cn99.c om... hi gurus, now I have to backup and restore a 8 T size db2 database. from
two s85 to two 670. the partitions,tabl espaces of the db should be redesigned then I plan to use redirected restore.
but my concern is, such big size db, I'm afraid something unexpected will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)
"Hardy" <We***********@ ibm.com> wrote in message
news:cf******** ***@mail.cn99.c om... hi gurus, now I have to backup and restore a 8 T size db2 database. from
two s85 to two 670. the partitions,tabl espaces of the db should be redesigned then I plan to use redirected restore.
but my concern is, such big size db, I'm afraid something unexpected will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)
First you need to guarantee if the approach can be workable. If the number
of target db partitions is different than the number of source db partitions
(you didn't tell us if you build multiple logical db partitions on each
physical node), redirected restore will not cover redirecting to different
db partition.
Second even you have the same number of db partitions on both source and
target site. Since you mentioned you need to redesign the tablespaces, then
which approach you will use to redistribute the data?
Third, how far are the source and target? Will you plan to backup to TSM,
and restore from TSM? Or others?
"Fan Ruo Xin" <fa*****@sbcglo bal.net> дÈëÓʼþ
news:58******** *********@newss vr17.news.prodi gy.com... "Hardy" <We***********@ ibm.com> wrote in message news:cf******** ***@mail.cn99.c om... hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tabl espaces of the db should be
redesigned then I plan to use redirected restore.
but my concern is, such big size db, I'm afraid something unexpected
will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)
First you need to guarantee if the approach can be workable. If the number of target db partitions is different than the number of source db
partitions (you didn't tell us if you build multiple logical db partitions on each physical node), redirected restore will not cover redirecting to different db partition.
the number of partitions will remain the same as before, in a safe
consideration.
but I really want to double the partitions(from 4 on each server to 8
on each server). I don't familar with things about partition, but I wonder
if I can
redirect a tablespace originally span on 4 partitions to new tablespace
which span on 8, then the data will be
redistributed in the 8 partitions. can it work? I'm very very new to do
database related things,
so maybe I had initiated a very foundamental question but only don't know
the key.
Second even you have the same number of db partitions on both source and target site. Since you mentioned you need to redesign the tablespaces,
then which approach you will use to redistribute the data?
en, maybe the 'redesign' is a exaggerated word here. I just want to let the
existing tablespaces distrubute
more reasonably on the new servers, ie. span on different partitions.
Third, how far are the source and target? Will you plan to backup to TSM, and restore from TSM? Or others?
on the same location.
there's no TSM. still not decided.maybe EMC.
en, if we copy the full db directory to the new server, the what can I do?
Is there a convenient way to help me
distribute the data in the new environment?
the backup/restore seem to be a very long period. I'm not very confident for
I cann't find
any reference case to deal with such large dbs. one senior engineer said
they had ever tried back/restore nTBs db(informix)
several times but no success. is there any safe way?
(db2look,export ,load...maybe work and easy to control, but the time...
how long can it be?)
very thankful to Ruxin:)
"Hardy" <We***********@ ibm.com> wrote in message
news:cf******** ***@mail.cn99.c om... "Fan Ruo Xin" <fa*****@sbcglo bal.net> дÈëÓʼþ news:58******** *********@newss vr17.news.prodi gy.com... "Hardy" <We***********@ ibm.com> wrote in message news:cf******** ***@mail.cn99.c om... hi gurus, now I have to backup and restore a 8 T size db2 database.
from two s85 to two 670. the partitions,tabl espaces of the db should be redesigned then I plan to use redirected restore.
but my concern is, such big size db, I'm afraid something unexpected will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)
First you need to guarantee if the approach can be workable. If the
number of target db partitions is different than the number of source db
partitions (you didn't tell us if you build multiple logical db partitions on each physical node), redirected restore will not cover redirecting to
different db partition.
the number of partitions will remain the same as before, in a safe consideration. but I really want to double the partitions(from 4 on each server to 8 on each server). I don't familar with things about partition, but I wonder if I can redirect a tablespace originally span on 4 partitions to new tablespace which span on 8, then the data will be redistributed in the 8 partitions. can it work? I'm very very new to do database related things, so maybe I had initiated a very foundamental question but only don't know the key.
(1) You CAN NOT backup a 8 db partitions database, and restore (even with
redirect) into a 16 db partitions database -:(
(2) You have to consider which way you need to go - build 8 db partitions on
each new box or build 4 db partitions on each new boxe first and then add
additional 4 db partitions later. This also determine the possible solution
about how to move the data from the old boxes to the new boxes. Second even you have the same number of db partitions on both source and target site. Since you mentioned you need to redesign the tablespaces, then which approach you will use to redistribute the data?
en, maybe the 'redesign' is a exaggerated word here. I just want to let
the existing tablespaces distrubute more reasonably on the new servers, ie. span on different partitions.
No, REDESIGN is a rather MAKE SENSE word. When the db systems need to be
upgraded to the new hardware environment, it is absolutely necessary for us
to consider REDESIGN, better use the new hardware power. The configuration
for the old hardware environment will not totally match the new environment.
And you also need to consider to take care of the data growing for the
following years (2, 3, 5, ...)
Third, how far are the source and target? Will you plan to backup to
TSM, and restore from TSM? Or others?
on the same location. there's no TSM. still not decided.maybe EMC. en, if we copy the full db directory to the new server, the what can I do? Is there a convenient way to help me distribute the data in the new environment?
the backup/restore seem to be a very long period. I'm not very confident
for I cann't find any reference case to deal with such large dbs. one senior engineer said they had ever tried back/restore nTBs db(informix) several times but no success. is there any safe way? (db2look,export ,load...maybe work and easy to control, but the time... how long can it be?)
Which backup/restore policy are you using today? How long will take you to
do the full db backup today?
DB2 UDB EEE has no problem to deal with backup/restore nTBs database size.
And you can also backup 32bit database, and restore into a 64bit database,
if they both use DB2 UDB version8.1. I never got a chance to use Informix
XPS, but I believe it can handle the db size like this scenario.
It is possible that Backup/Restore might take you days. But ...
- DB2 UDB EEE can backup each db partitions in parallel. Only during the
offline full db backup, you need to backup catalog db partition first. But I
don't know if your catalog db partition contains a lot of user data.
- From what you tell us here, if your catalog also contain the user
tablespace, like all the other non-catalog nodes, then each db partition
size is about 1 TB. Is this the size of each db partition backup image?
- Again, if you want to use this way - backup/restore, do you want to use
TSM (Tape), fs, EMC, ...? The performance is totally different. Do you use
EMC for your current system?
Unload(especial ly if you use HPU) and load approach is a very good choice.
You need to be serious to think this. By using this way, you can dump the
data from a 8 db partitions database and load into a 16 db partitions
database. You don't need to worry about the data redistribution.
But there are always some tradeoff, advantage/disadvantage for each way.
I am afraid no one can give you the answer - how long will it be?
Any one if he/she wants to give you the answer, he/she need to do a batch of
research about your current environment, and need to know more detail
information about the new environment ... -:(
very thankful to Ruxin:) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: James |
last post by:
HI,
I'm looking for a script that will allow users/admins to have a one
click backup solution for a MYSQL Database..
'BACK DATABASE' button, click and its done...
The a restore option, that shows all current backups, and restores the
selected one with one click...
|
by: Tim Morrison |
last post by:
MSDE2000
I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the following:
1) Ran a BACKUP DATABASE command to a file named C:\TEST.BAK.
2) Deleted the database completely.
3) Ran a RESTORE DATABASE on the same file (note, I did NOT recreate the database)
Now I have the database back with all my data....
|
by: Spieg |
last post by:
I've a program with VB6 working with SQLServer 2000.
I have a Central Station with the program runnin with full prvileges and
that can perform all the actions on the DB.
There are also some clients that cannot be connected via LAN or internet
that need to use the same DB.
The way I solved this with Aces was to copy the Access file from the Central
Station ot the disconnected clients.
Then to update the central Staton I used to save the...
|
by: anton.aleksandrov |
last post by:
Hello,
First of all - sorry for may be stupid question, but as I am not a
Win* administrator and my field is *nix, I am a little bit stuck with
a problem, presented to me by one of the customers. He has few windows
boxes with some webfile and (most important) - mssql database. And he
asks for a backup. I found some company, which offers us IBM's Tivoli
software, but my opinion is that they want a little bit too much for
it and also, from...
|
by: UnixSlaxer |
last post by:
Hello,
- I have a database, which i want to backup, not only the data, but
also the indexes and views/procedures associated with it. Is the
backup/restore operations (Through the DB2 Control Center) sufficient ?
- And what happens if I later on add an index, and then restore the old
database, will this new index/view be removed ?
Any help would be appreciated.
| |
by: javelin |
last post by:
I'm having difficulty searching for an answer to this challenge. Can
someone give me a clue on the right keywords to use to find a
discussion on this subject? All of the ones I saw appear to touch on
older versions. I'm working with SQL Server 2000, and need to backup
and restore only tables, because the full backup/restore appears to
mess up users/security, or something or another.
Thanks for the assist.
|
by: clilush |
last post by:
I've been working with db2 8.2fp14 for over a year now and was
wondering what is a "standard" way of doing a backup to provide 24/7
operations with disaster recovery capabilities?
My thoughts were an offline backup once per quarter, followed by a
monthly online backup, followed by daily backups of the logfiles.
BUT it's the details of each that I'm wondering...
1- how can i tell what logfiles need to be backedup? is there a way to
"trim"...
|
by: aka |
last post by:
Hi,
I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from
a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit,
Big-endian) server located in US. The target server has DB2 V8.2 FP 15
installed and instance name and filesystem user groups rights an so on are
all identical.
From the manuals I see that a crossplatform backup-restore should be
supported between the two systems.
I did a full offline...
|
by: Niheel |
last post by:
The importance of backups can never be emphasized enough. In Vista Ultimate and Windows Server 2008, there is a built in feature to take care of backups called Windows Complete PC Backup and Restore.
It can be found by:
Start >> All Programs >> Maintenance >> Backup and Restore Center
Backing Up Your Data and PC
Backup my files
If you only want to back up your important files and data, Backup and Restore Center gives you this option.
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |