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

    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 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

    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