Question
If you want to restore a table space level backup image, the table space must exist prior to the restore operation, and the restore operation must be targeted to the same database. (This does not apply to version 9.5 or later if you are performing a RESTORE ... REBUILD operation using table space restores.)
Answer
Symptom: SQL2549N (the database was not restored because either all of the table spaces in the backup image are inaccessible, or one or more table space names in list of table space names to restore are invalid) while trying to restore a table space-level backup with redirect.
Cause: SQL2549N is returned if the table space has been dropped prior to the restore operation.
Action: Do not drop a table space if that table space is to be restored from a table space-level backup image, even if you want to change the container path. If you want to restore a table space level backup image, the table space must exist prior to the restore operation, and the restore operation must be targeted to the same database.
'Db2 > Db2 reference' 카테고리의 다른 글
9.7부터 변경된 CHAR 스칼라 함수 동작 (dec_to_char_fmt) (0) | 2013.02.18 |
---|---|
아카이브 로그 관리 (0) | 2012.08.24 |
db2pd 명령을 사용하여 모니터링 및 문제점 해결 (9.7) (0) | 2012.08.09 |
Kernel parameter tuning on HP-UX, Oracle Solaris and Linux (0) | 2012.07.21 |
사용자의 DB접속을 막는 4가지 방법 (0) | 2012.07.21 |