What are the benefits of tablespaces in DB2?
DB2 – Tablespaces 1 Introduction. A table space is a storage structure, it contains tables, indexes, large objects, and long data. 2 Benefits of tablespaces in database. Recoverability: Tablespaces make backup and restore operations more convenient. 3 Container. Tablespaces contains one or more containers. 4 Default tablespaces.
How are table spaces stored in a database?
A table space is a storage structure, it contains tables, indexes, large objects, and long data. It can be used to organize data in a database into logical storage group which is related with where data stored on a system. This tablespaces are stored in database partition groups
What to do with the list tablespaces command?
The LIST TABLESPACES command lists table spaces and information about table spaces for the current database. Important: This command or API has been deprecated in Version 9.7 and might be removed in a future release. You can use the MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions instead which return more information.
What does it mean to have a temporary table in DB2?
Temporary tablespace: A temporary tablespace contains temporary table data. This tablespace contains system temporary tablespaces or user temporary tablespace. System temporary tablespace holds temporary data required by the database manager while performing operation such as sorts or joins.
How to restore tablespace from DB2 backup image?
To restore tablespace USERSPACE1 from a backup image (database level or tablespace level): $ db2 “restore db sample tablespace (USERSPACE1) taken at 20141013180552”. DB20000I The RESTORE DATABASE command completed successfully. After the restore, the tablespace is now is a rollforward pending status: $ db2 rollforward db sample query status.
What does the erase statement do in DB2?
PRIQTY: Specifies the minimum primary space allocation for a DB2-managed data set. SEQQTY: Specifies the minimum secondary space allocation for a DB2-managed data set. ERASE: Indicates whether the DB2-managed data sets for the table space are to be erased when the corresponding table space is deleted. NO: It does not erase the data sets.