This article mainly tells you about the usage skills of DB2 Resotre when using TSM. I saw materials about the usage skills of DB2 Resotre when using TSM on the relevant website a few days ago, I think it's good. I just want to share it with you.
1: query the time of all backups db2adutl query full database; 2: Restore according to the time queried: db2 restore database use TSM taken at WITHOUT PROMPTING
1: query the time of all backups
- db2adutl query full database
2: Restore Based on the query time
- db2 restore database use TSM taken at WITHOUT PROMPTING
Note: without prompting can be used based on actual conditions.
3: confirm the Rollforward time and the required active_log.
- db2 list history backup since for
Note: The Rollforward time here refers to the end time of Backup.
The end time found here is to be changed before rollforward can be used.
- 20091226023557 > 2009-12-26.02.35.57
- exp:
- db2 list history backup since 20091226 for sample
4: Put active_log in archive pass from TSM
Dsmc restore-subdir = yes-pitdate = <backup time to be restored>
5: Perform Rollforward
Db2 "rollforward database to <at 3 confirmation time> using local time and complete"
6: perform database activity.
- db2 activate database
The above content is an introduction to the DB2 Resotre usage skills when using TSM. I hope you will get some benefits.
The above content is a description of the DB2 Resotre usage skills used in TSM. I hope it will help you in this regard.