Symptom
You notice tablespace is not accessible after the load operation on the tables which reside in this tablespace.
LIST TABLESPACES command shows the tablespace is in "Backup Pending" state.
Tablespace ID = 2
Name = ABC#BTABD
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0020
Detailed explanation:
Backup pending
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
SQL1092N, 0x0020, backup pending, load, copy no , KBA , backup pending , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , How To
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.