Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: Incremental Backup is taking long time

    Hi Gurus,
    Since a Month, the incremental backup which db is 16TB size taking very long times.
    This is a Transactional database. All to-gether i am interested to identify the bottle necks in this database.

    1. we do monthly online reorgs
    2. we have very large tables which reorg will be paused and resumed for 5 to 6 months.


    i see lot of tablespaces recording with high read/write times. can you please guide me where to start identifying the bottle neck and plan to stream-line the backup runitmes

    Rgds/

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Lots of questions:
    What DB2 version and OS are you using?
    How long is the incremental backup taking?
    How long does the full backup take?
    Where are you sending the backups (both full and incremental)?
    What frequency are you doing the full and incremental backups?
    To what extent, do the reorgs change the tables?
    How fast do the data in the tables change?

    Andy

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    This is a frequently asked question.
    For each table that has a large-object column is there a dedicated tablespace for large-objects...
    Are you backing up to disk, (local, remote, ?), or tape (shared? dedicated? how much staging space etc).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •