Hi All,
We are haveing 4 DB's in our company, and presently we used to take
offline backup on once in a week, we knew we cant recover last-in-time
data. But we would like to shift to some new technique which saves
time, sapce & last-in-time recover. we heard about the online backups
and incremental backups, what are they actually, what is the
differences. Here the main requirements is recovering the with- miniual
loss and 24x7 availability is needed.
I will be greatfull if someone could help me on this issue asap.
Thanks
Anantha
(sm**********@g mail.com) 8 1633
Your best source of information is the section entitled "Recovering Data"
under "Tasks" - "Administer ing database systems" in the DB2 documentation.
"Anantha" <sm**********@g mail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. . Hi All, We are haveing 4 DB's in our company, and presently we used to take offline backup on once in a week, we knew we cant recover last-in-time data. But we would like to shift to some new technique which saves time, sapce & last-in-time recover. we heard about the online backups and incremental backups, what are they actually, what is the differences. Here the main requirements is recovering the with- miniual loss and 24x7 availability is needed. I will be greatfull if someone could help me on this issue asap.
Thanks Anantha (sm**********@g mail.com)
Hi,
and/or the "Data Recovery and High Availability Guide and Reference"
( http://www-306.ibm.com/software/data...anualsv8.html).
8.2 (8.1.7) has some very nice features addressing high availability
needs and eases the whole log management, but you need a proper strategy
(24x7 needs more than only a good backup plan).
Regards,
Bernd
DB2 V8.2 offers the following support for recovery. Define your DB's with
the logretain parameter set to RECOVERY.
You can then do:
1) Full Database or Tablespace backups. Offline or Online.
2) Full Database Restore (Always offline)
3) Selective Tablespace Restore, offline or online.
Moreover, there are a series of parms. in your DB CFG that allow you to
define how thearchiving of your logs will be handled.
I would suggest some reading of the DB2 UDB Administration Guide which tyou
can access on line.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Anantha" <sm**********@g mail.com> a écrit dans le message de news: 11************* *********@z14g2 00...legr oups.com... Hi All, We are haveing 4 DB's in our company, and presently we used to take offline backup on once in a week, we knew we cant recover last-in-time data. But we would like to shift to some new technique which saves time, sapce & last-in-time recover. we heard about the online backups and incremental backups, what are they actually, what is the differences. Here the main requirements is recovering the with- miniual loss and 24x7 availability is needed. I will be greatfull if someone could help me on this issue asap.
Thanks Anantha (sm**********@g mail.com)
Thanks for the support, I have been starting looking the guide.
Hi Anantha:
I am not sure what version of DB2 you are running, but if it's 8.2 and
you need 24x7, here is a few things you can get started:
1. Save space - Use compression. In my shop, i get 66% compression.
2. Speed - Backup to disk and let the disk be backed up to TSM at a
later time. Straight backups to TSM / any storage device are time
consuming and can't beat the speed you get with disks.
3. I am not sure about the size of DB, but 8.2 self tunes the backup
performance. We usually backup a 44 gig DB into a 12 gig comperssed
image to disk in 20 minutes.
4. Use mirror logpath, just incase logs disappaer from active path
5. If you don't have multiple hardware resource to do logshipping/HADR,
TrueCopy (HITACHI Term for bit-to-bit copy), udb replication to
maintain a warm standby, then device a plan to take full, incremental
and delta backups to keep the recovery time as short as possible. In
my shop, we have 5 copies of DB on two different DR sites and we only
take daily full backups and retain 3 day old images on TSM.
HTH
Vijay
Anantha
Could you please specify following-
your db size :
Available space :
Recovery time objective:
(How much time is available if you have to recover)
Recovery point objective:
(How much data lose is acceptable )
Based on above requirement I can help you to come up with your BR strategy.
--
Jay
IBM DB2 Engineer
NetApp Inc.
Hi Jay & All,
The size of the DB is 5GB and, Recovery time objective is not an
constraint, but last point-in-time data recover. I would like to know
steps to do this, and wat are the tools and how should run these
process.
Thanks & Regs
Anantha
The database is small enough that you only need to use log retention, online
backup proceudres and the user exit to move log files to the backup media.
See the DB2 documentation for the details.
"Anantha" <sm**********@g mail.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. . Hi Jay & All, The size of the DB is 5GB and, Recovery time objective is not an constraint, but last point-in-time data recover. I would like to know steps to do this, and wat are the tools and how should run these process.
Thanks & Regs Anantha This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Smith |
last post by:
Hi
I am currently reviewing our backup procedures. Part of the issue has been
finding the right fit. There are obviously backup products that provide
mysql agents but unfortunately can not for fill our complete backup/disaster
requirements. I have evaluated bakbone, arkeia, brightstor, veritas. I am
currently looking at evault, commvault and ipstor.
I am now looking to separate mysql from the rest of the backup. I am
looking to...
|
by: nt |
last post by:
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the T-SQL is:
BACKUP DATABASE GPRS_Dimensioning_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040706'
Note that "local_backup" is a file sitting on the same physical drive
as the database itself, and has > 80 GB free. It is not a RAID...
|
by: EggsAckley |
last post by:
Hi:
I have a file that I have been told is a SQL Server backup from a
server somewhere. The file is about 200MB in size
I am trying to create the database on my local server using RESTORE. I
created the backup device, associated it with a backup name etc.,
copied the file into the backup dir.
When I run the RESTORE command, Query Analyzer tells me the database
|
by: Andrew Rawnsley |
last post by:
Anyone out there using beta 2 in production situations? Comments on
stability? I am rolling out a project in the next 4 weeks, and really
don't want to go though an upgrade soon after its released on an
Unsuspecting Client, so I would LIKE to start working with 7.4.
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
|
by: alex |
last post by:
Hi !
I couldn't make backups with our new system using db2 8.2.
Every time I trigger a backup I get this error message:
BACKUP DATABASE EBUERO2 ONLINE TO "/raid/backup/ebuero2/part1",
"/raid/backup/ebuero2/part10", "/raid/backup/ebuero2/part11",
"/raid/backup/ebuero2/part12", "/raid/backup/ebuero2/part13",
"/raid/backup/ebuero2/part14", "/raid/backup/ebuero2/part15",
"/raid/backup/ebuero2/part16", "/raid/backup/ebuero2/part17",
| |
by: ChrisWinterscheid |
last post by:
We are running DB2 8.1 on AIX 5.2.
DB2level shows:
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08016"
with level identifier "02070106".
Informational tokens are "DB2 v8.1.1.56", "s040616", "U497635", and FixPak
"6".
Product is installed at "/usr/opt/db2_08_01".
|
by: Richard Hollenbeck |
last post by:
I'd like a button on my main form to backup the database. How can I call up
the Windows folder browser to prompt me for a filename and type (*.mdb) and
folder to save in? I looked in my book and didn't see anything like that.
I only want to backup the data tables in the back-end database. Is there
some standard set of code to do this?
Thanks, Rich Hollenbeck
|
by: HSP |
last post by:
hi.
i need to restore an old database. The db was backed up using a DLT drive,
using 2 volumes. The content for the tapes was copied to file onto Solaris
machine using rsh and dd (for backup purposes). Now, the drive is defective
and can't read the tapes anymore.
Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version
2.1.2)
|
by: laststubborn |
last post by:
Dear All,
We have a big concern in our Database system. We have 2000 transactions
daily in our database. We need to replicate some how the database for
our fail over setup. I tried transactional replication at midnight but
our all systems locked and we had a lot of complaints from the
customers and It was taking a lot of time to snapshot part and I had to
abort it because of these reasons.
I need an advice how I can create a replication...
|
by: smoi |
last post by:
Hi all,
My manager ask me to do backup for 3 database and restore them in a new server.
I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the following:
1. Microsoft SQL-DMO (ODBC SQLState: 4200) The media family on device 'C:\Backup.BAK' is...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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: 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: 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: 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.
| |