SAP Knowledge Base Article - Preview

2513945 - DB6: Tablespace "Backup Pending" state after load operation

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.