473,287 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

backup/restore nTs data

hi gurus, now I have to backup and restore a 8 T size db2 database. from two
s85 to two 670. the partitions,tablespaces 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:)
Nov 12 '05 #1
4 3773
oh, why no one reply to me? 55~~

"Hardy" <We***********@ibm.com> дÈëÓʼþ news:cf***********@mail.cn99.com...
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces 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:)

Nov 12 '05 #2

"Hardy" <We***********@ibm.com> wrote in message
news:cf***********@mail.cn99.com...
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces 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?
Nov 12 '05 #3

"Fan Ruo Xin" <fa*****@sbcglobal.net> дÈëÓʼþ
news:58*****************@newssvr17.news.prodigy.co m...

"Hardy" <We***********@ibm.com> wrote in message
news:cf***********@mail.cn99.com...
hi gurus, now I have to backup and restore a 8 T size db2 database. from two
s85 to two 670. the partitions,tablespaces 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:)


Nov 12 '05 #4

"Hardy" <We***********@ibm.com> wrote in message
news:cf***********@mail.cn99.com...

"Fan Ruo Xin" <fa*****@sbcglobal.net> дÈëÓʼþ
news:58*****************@newssvr17.news.prodigy.co m...

"Hardy" <We***********@ibm.com> wrote in message
news:cf***********@mail.cn99.com...
hi gurus, now I have to backup and restore a 8 T size db2 database.
from
two
s85 to two 670. the partitions,tablespaces 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(especially 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:)

Nov 12 '05 #5

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

Similar topics

3
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...
3
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...
2
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...
2
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....
3
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...
6
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...
2
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...
3
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...
0
Niheel
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.