SQL2563W The restore process has completed successfully

12 April,2012 by Tom Collins

Question:  I am getting the SQL2563W  messages on a DB2 database restore

SQL2563W  The restore process has completed successfully, but one or moretable spaces from the backup were not restored.

How do I resolve the SQL2563W messages?

 Answer: The SQL2563W message means the restore is completed , but at least one of the tablespaces is not restored.



a)      Check if tablespaces have been dropped since the last backup

b)       Check to see if tablespaces used by the tablespace containers in the backup exist in the target environment

c)  Check backup command and contents of a database

Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL2563W The restore process has completed successfully

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright