> 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