Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: DB2 backups running slow

    I am running a full online database backup on DB2 UDB 7.2 FP6 with AIX 5.2L both 32 bit. Normally the backups only take 2-3 hours but for some reason lately the backups are running MUCH SLOWER than usual. Like 5-6 hours. Any way to improve performance of backups? Thanks.

    Scott

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 backups running slow

    Could be other activity on the system ...

    You can use buffer size, numbuffers,parallelism, numsessions(if you are using TSM) etc ...

    Cheers
    Sathyaram

    Originally posted by mixxalot
    I am running a full online database backup on DB2 UDB 7.2 FP6 with AIX 5.2L both 32 bit. Normally the backups only take 2-3 hours but for some reason lately the backups are running MUCH SLOWER than usual. Like 5-6 hours. Any way to improve performance of backups? Thanks.

    Scott
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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