Results 1 to 4 of 4

Hybrid View

  1. #1
    Member
    Join Date
    Mar 2008
    Location
    Madison, WI
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Span database across multiple disks

    Hi guys, first off this is TSM 5.5 on AIX.

    Our main TSM guy is swamped getting other work done prior to a planned medical leave, so I'm going to try and pick up some of the TSM slack. Let me just say I'm no TSM expert, and only have an intermediate operating understanding of how it works.

    I've noticed our backups and expirations taking quite a long time to finish. At one point, one expiration process had been running for a few weeks. I had to suspend backups for a day on a few occasions to let expiration catch up. Thankfully, we only rely on TSM as a secondary backup/recovery method.

    I did a little digging, and found out that our database is living on one of our SAN arrays, as this was supposed to be faster than the pSeries local disk (I can't confirm this). This volume is also a destination for our daily Exchange and SQL backups, so it's getting hit pretty hard. Looking at nmon, this disk is at 100% io all the time. This appears to be the source of slow backups and expirations, or anything database intensive.

    So, is there a way to span the DB across multiple disks to help the io load? Thanks for any help, and I apologize for being a noob.

  2. #2
    Member
    Join Date
    Apr 2009
    Posts
    63
    Thanks
    0
    Thanked 10 Times in 10 Posts

    Default

    Why don't you get some TSM performance tracing first before jumping down the rabbit hole? You're more than likely on the right path since it doesn't sound like your configuration follows "best practices," but there are some other factors that can cause slow expiration as well.

    http://www-01.ibm.com/support/docvie...id=swg21326204

  3. #3
    Member
    Join Date
    Mar 2008
    Location
    Madison, WI
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks.

    Maybe I'll take a step back and do some number gathering. Beyond the dozens of other performance no-no's we're doing, I feel the 100% used disk is the biggest factor. By simply stopping backups, expiration probably went 20 times faster.

    I'll take a good look at your link, thanks.

  4. #4
    Member
    Join Date
    Mar 2008
    Location
    Madison, WI
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Just a follow up for the record.
    We ended up migrating the database to a newer array and all of the problems are gone. This is the smoothest TSM has run in years.

Similar Threads

  1. Replies: 2
    Last Post: 02-08-2011, 06:41 PM
  2. How to configure disks for log and database
    By Masonit in forum TSM Server
    Replies: 0
    Last Post: 01-13-2011, 10:30 AM
  3. Tape Span - Multiple drives
    By kvwar in forum Tape / Media Library
    Replies: 3
    Last Post: 04-08-2010, 09:33 AM
  4. Local Disks now Showing up as Cluster Disks
    By rtiebout in forum Backup / Archive Discussion
    Replies: 6
    Last Post: 07-01-2009, 10:38 AM
  5. Archive "all-local" disks without explicitly nominating disks ...
    By peters66 in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 05-27-2004, 05:20 AM

Posting Permissions

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