Symptom
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'
Read more...
Environment
Db2 Linux Unix and Windows
Product
SAP enhancement package 8 for SAP Strategic Enterprise Management 6.0
Keywords
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.