SAP Knowledge Base Article - Preview

3246138 - One or more tablespaces not restored as part of restore operation.


After performing a restore operation you encounter one or more of the following:

  • In the db2diag.log the warning 'SQL2563W The restore process has completed successfully, but one or more table spaces from the backup were not restored."
  • One of more tablespaces are in a RESTORE PENDING ( 0x100 ) state
  • On tablespace access post restore you receive 'SQL0290N Table space access is not allowed'



Db2 Linux Unix and Windows


SAP enhancement package 8 for SAP Strategic Enterprise Management 6.0


KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.