By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

DB2 Concepts

P: n/a
Hi,

1.) What is the Compress option in Backup ? How can we find the size
of the compressed
image ? What is the db2adutl command ?

2.) Suppose I take a backup image in DB2 UDB 8.1 Fixpak 7 and my O.S.
crashed.
Now, I install the O.S again and I install DB2 UDB 8.2 Fixpak 11
and I need to
create my Database. Can I use the backup image created in DB2 UDB
8.1 Fixpak 7
to a higher version to recreate the Database.

Has this some thing to do with Version Recovery ?

3.) During a backup operation , how do I take images to multiple
sites ? i.e can I take backup in
different devices at the same time

4.) I have the following DB Configurations
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO

How do I find out why the Database is not Consistent ?

5.) What is the use of Track modified pages (TRACKMOD) ? If its ON,
will it have an impact in the backup timing ? In an incremental backup
scenario will DB2 check the changed pages and there by lower backup
timings ?

6.) What will the NUM_BUFFERS of the BACKUP option depend on ?

regards,
RaInDeEr

Jul 30 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rAinDeEr wrote:
Hi,

1.) What is the Compress option in Backup ? How can we find the size
of the compressed
image ? What is the db2adutl command ?
You can use the "du" or "ls" OS commands and look at the backup image itself
to find its size.
2.) Suppose I take a backup image in DB2 UDB 8.1 Fixpak 7 and my O.S.
crashed.
Now, I install the O.S again and I install DB2 UDB 8.2 Fixpak 11
and I need to
create my Database. Can I use the backup image created in DB2 UDB
8.1 Fixpak 7
to a higher version to recreate the Database.
Yes, you can restore a backup taken from an earlier FP level. In fact, you
can also restore a V7 backup into a V8 DB2. (I think that is what "version
recovery" may refer to.)
4.) I have the following DB Configurations
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO

How do I find out why the Database is not Consistent ?
Because you have connections to the database that changed some data in some
tables?
5.) What is the use of Track modified pages (TRACKMOD) ? If its ON,
will it have an impact in the backup timing ? In an incremental backup
scenario will DB2 check the changed pages and there by lower backup
timings ?
I know I'm not very polite right now, but have you actually read the manual?
First hit when I search for TRACKMOD gives this:

When this parameter is set to "Yes", the database manager tracks database
modifications so that the backup utility can detect which subsets of the
database pages must be examined by an incremental backup and potentially
included in the backup image. [...]

http://publib.boulder.ibm.com/infoce...c/r0004469.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jul 30 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.