Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: DB restore with TSM sessions

    I have backed a database with 2 open sessions on TSM server.
    The backup took 15 hrs. Now when I restore the database what is the difference in performance (time it takes to restore the db) if I give the command restore db.....open 2 sessions....parallelism 6
    vs the command restore db .... paralleslism 6 (without mentioning any open session in the restore command)

  2. #2
    Join Date
    Aug 2003
    Location
    INDIA,CHENNAI
    Posts
    3

    tms backup

    Based on my experience, backup time is less than the restore time.

    If u are using 4 processors u can give parallelism 4.

    In my 4 processor system to take 75 GB of databackup using,

    backup db <dbname> use tsm open 1 sessions with 12 buffers buffer 4096 parallelism 4,

    taking 1 hr.

    sessions is depend upon your TSM server setup. Best practice is, based upon the server setup(DB and TSM) use iterative method to reach the better performance in backup and restore

Posting Permissions

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