Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2007

Tip: Looking for answers? Try searching our database.

DB2 Concepts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rAinDeEr - 30 Jul 2007 09:40 GMT
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
Knut Stolze - 30 Jul 2007 13:53 GMT
> 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.
[quoted text clipped - 3 lines]
> 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
[quoted text clipped - 3 lines]
>
>      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/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/r0004469.htm


Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.