Analysis of the actual operation steps for DB2 to restore a tablespace

This article mainly describes the actual operation steps for DB2 to restore a tablespace. If you encounter the problem of restoring a tablespace in DB2, however, you do not know how to solve the problem correctly, so the following articles must be good teachers and friends for you.

Space

Online archiving and database backup,

Delete the dms tablespace, and then delete the file in the dms tablespace,

Using DB2 list tablespaces, we can see that some tablespaces are offline,

Now, I want to restore the tablespace. Apart from restoring the entire database, is there any way to restore this dms tablespace, instead of anything else.

My database is installed on linux5 and uses V8.1,

I use

 
 

  
  
DB2 "restore db testdb rebuild with tablespace ( SYSCATSPACE, TB1) from $HOME/online" 
 
 

Result prompt

 
 

  
  
SQL0104N an unexpected token "rebuild" was found following "<identifier>".  
  
  
expected tokens may include : "continue", SQLSTATE=42601  
 
 

The above content is an introduction to restoring a table space in DB2. I hope you will get something better.

The above content is an introduction to restoring a table space in DB2. I hope you will get something better.