473,385 Members | 1,890 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,385 software developers and data experts.

backup with multiple targets

Hi All,
I was trying to make backup faster so After studying I used this cmd
for backup:-

db2 backup db <dbname to /bkup/dir1, /bkup/dir2 compress without
prompting;
backup went successful and it was faster than previous too.

But need help to understand the procedure to restore from these 2
images. please Help.

Thanks
sandy
Oct 20 '08 #1
2 2090
On Oct 20, 10:39*pm, "sandeep.i...@gmail.com" <sandeep.i...@gmail.com>
wrote:
Hi All,
I was trying to make backup faster so After studying I used this cmd
for backup:-

db2 backup db <dbname*to /bkup/dir1, /bkup/dir2 compress *without
prompting;

backup went successful and it was faster than previous too.

But need help to understand the procedure to restore from these 2
images. please Help.

Thanks
sandy
What's the problem with

db2 restore db <dbnamefrom /bkup/dir1,/bkup/dir2 without rolling
forward

Consider also that backup may be considerably faster without the
compress option.
Oct 21 '08 #2
hi ,
I will try your cmd. i haven't tried it as i was not confirmed that
it will work or not?

as far as command without compress shud take less time but compression
is reducing my backup image size by 10 times.

right now its taking 50 min. can you tell me any disadvantage of using
multiple backup image....Like more time required when
restoring ....plz enlighten me :)

Thanks in advance.
Sandy
Oct 21 '08 #3

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

Similar topics

2
by: newbiegca_sqlsever2000 | last post by:
Question 1 3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD Database size 10 GB - How long will full database backup take if the backup is writing a file to the hard disk...
6
by: Eric Herber | last post by:
I've a question regarding db2 (V8.1) and database backups going to a storage manager like TSM for example. As I can see in the storage manager if I backup the complete database over the TSM API...
4
by: Hardy | last post by:
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...
2
by: Kums | last post by:
How much time does it take to backup a datbase of size 2 terra byte? Can you specify the tool you use, technique and registry variables with values for your system, so that I get an idea? How...
2
by: A. Gupta | last post by:
I'm compiling a project that I want to have multiple targets (basically debug and optimized). I would like to just be able to type 'make debug' or 'make optimized' and have the makefile compile...
6
by: Steven | last post by:
I have a problem with moving the backup of my database from machine to machine. The size is 17 Gig and my network keeps timing out when I try to ftp it from machine to machine. I have had the...
4
by: snoconegod | last post by:
Hi all, This one's probably super easy and I'm just not finding the right command/job: I've already set up a scheduled backup job that dumps the contents of my DB2 (ver 8.1) database to a...
7
by: Olegus | last post by:
Hello, in order to perform backup/restore MSSQL database using SMO, one needs to reference several namespaces in a backup class : using Microsoft.SqlServer.Management.Common; using...
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...

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.