473,325 Members | 2,860 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,325 software developers and data experts.

Backup Question

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.

Thanks

Regards,
Salem

Nov 12 '05 #1
3 1615
"UnixSlaxer" <un********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
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.

Thanks

Regards,
Salem

A database backup includes everything, except for certain DB2 environment
variables (DB2SET) and database manager instance variables (dbm dfg),
neither of which are specific to a database. In certain cases, if you
restore a database that already exists, some database level configuration
variables (db cfg) are not over-written with a restore.

However, all DDL (tables, indexes, views, etc, and procedures, etc) are
contained in the database backup, in addtion to the data. So if you restore
the entire database to a prior point in time, you will loose any changes
made after that backup time. But if you restore the database and roll the
logs forward, DB2 will reapply any changes up to the latest consistent
commit point on the logs (or some other point in time you define). In order
to roll the logs forward, you will need LOGRETAIN = ON (or the user exit
program defined).

If you don't want to restore procedures, indexes, etc (only restore data),
you could do a tablespace restore. Tablespace restores also require
LOGRETAIN = ON.
Nov 12 '05 #2
Thank you very much for your response. I appreciate it.

Best Regards,
Salem

Nov 12 '05 #3
This is pretty rare, but if you happen to write an external user-defined
function, the binary part of it won't be backed up, as it is a file sitting
in your functions directory. You wouldn't really expect something like this
to be backed up, but its easy to forget about and would be a bummer if you
lost your only copy.

"Mark A" <no****@nowhere.com> wrote in message
news:u_********************@comcast.com...
"UnixSlaxer" <un********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
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.

Thanks

Regards,
Salem

A database backup includes everything, except for certain DB2 environment
variables (DB2SET) and database manager instance variables (dbm dfg),
neither of which are specific to a database. In certain cases, if you
restore a database that already exists, some database level configuration
variables (db cfg) are not over-written with a restore.

However, all DDL (tables, indexes, views, etc, and procedures, etc) are
contained in the database backup, in addtion to the data. So if you
restore the entire database to a prior point in time, you will loose any
changes made after that backup time. But if you restore the database and
roll the logs forward, DB2 will reapply any changes up to the latest
consistent commit point on the logs (or some other point in time you
define). In order to roll the logs forward, you will need LOGRETAIN = ON
(or the user exit program defined).

If you don't want to restore procedures, indexes, etc (only restore data),
you could do a tablespace restore. Tablespace restores also require
LOGRETAIN = ON.

Nov 12 '05 #4

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

Similar topics

1
by: Andrew E | last post by:
I just took over DBA responsibilities for an Oracle 8i database running on Linux. Although I've been working with relational databases for some time, I'm a bit green on Oracle so forgive me. My...
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...
0
by: newbiegca_sqlsever2000 | last post by:
SQLServer 2000 Backup question. Let us say we have a database where data is stored in filegroup F1 and Filegroup F2 Backup of this is done on alternate days Day 1 - Full backup of file...
1
by: Louis | last post by:
This is maybe a dumb question but I couldn't find a definitive answer on BOL. Looking at my backup script. If I issue a CHECKPOINT, does this truly force all transaction log entries to the data...
1
by: jane | last post by:
HI, I had a question on incremental backup. We had an incremental backup every weekend. We did full backup every other week. That is one week incremental + full , the other week is...
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...
2
by: Trent | last post by:
Hello, all. I have the following production DB2 environment. DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003 standard edition. My first question is regard with...
4
by: uthuras | last post by:
Hi all, I have DB2ESE version 8.1 with FP 4 on AIX 5.2. My database used to be 1.1TB. When the DB size is 1.1TB, it takes approximately 7 hours to backup the entire database (online backup). The...
4
by: manwiththeaxe.70 | last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now...
5
by: jag | last post by:
hi, I am thinking about backup strategy. I have couple of questions for my db2 community brothers. 1. Can i use full online or offline database backup as base for incremental backup for...
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
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...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.