DB2 Concepts

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • rAinDeEr
    #1

    DB2 Concepts

    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

    Tags: None
    • Knut Stolze
      #2
      Re: DB2 Concepts

      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/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0004469.htm


      --
      Knut Stolze
      DB2 z/OS Utilities Development
      IBM Germany

        Comment

        Previous template Next
        Working...