Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  New: New option for backup database

    Posted 03/31/21 12:10 PM

    The backup database has a new option: NO TABLESPACE. A NO TABLESPACE backup does not contain tablespaces.

    NO TABLESPACE
    Specifies a no tablespace backup. A no tablespace backup does not contain tablespace, but in particular, the history file that can be restored by using the HISTORY FILE options with the RESTORE DATABASE command.

    #Db2


  • 2.  RE: New: New option for backup database

    Posted 03/31/21 12:10 PM

    Hello,

     

    beside the history file, what might be a use case for backup without tablespaces?




  • 3.  RE: New: New option for backup database

    Posted 03/31/21 12:10 PM

    Getting a consistent backup of the history file is the intended use case.

    Such a NO TABLESPACE backup also contains the other meta data of a database like bufferpool configuration, database configuration, database container location, storage paths. This information can be accessed by db2ckbkp/db2adutl and RESTORE GENERATE SCRIPT. I have found no use case for this additional information.


    Original Message


Related Content