What are the different types of tablespaces in DB2?
What are the different types of tablespaces in DB2?
Types of DB2 table spaces
- Universal (UTS) table spaces.
- Segmented (non-UTS) table spaces (deprecated)
- Partitioned (non-UTS) table spaces (deprecated)
- EA-enabled table spaces and index spaces.
- Large object table spaces.
- XML table spaces.
- Simple table spaces (deprecated)
What is the use of Runstats in Db2?
RUNSTATS is a DB2 utility that scans a table space or indexes to gather information about space utilization and index efficiency. The information gathered is stored in the DB2 system tables and used by the SQL optimizer to select the best access paths during the bind process.
Which one best describes why cursor is used?
Cursors are used by database programmers to process individual rows returned by database system queries. In SQL procedures, a cursor makes it possible to define a result set (a set of data rows) and perform complex logic on a row by row basis.
What are the different types of table space in DB2?
Catalog Table Space: This is used to store all the catalog tables maintained by the DB2 database. Generally this Table space gets created at the time of Database creation and named as SYSCATSPACE. Regular Table space: This table space is used to store all the permanent table data and indexes. This can be either DMS or SMS.
What is a table space in a database?
Table space is a database object where actually the table data gets stored. It is a like child of the database, where there can be multiple table spaces within a database. Each table space contains the ‘containers’. There can be one or more containers per table space.
How to get one row per table Partition in DB2?
On Db2 for LUW you can use this query. You get one row per table data partition (1 row for a non range partitioned table).
What are the default tablespaces for a database?
When you create a new database, the database manager creates some default tablespaces for database. These tablespace is used as a storage for user and temporary data. Each database must contain at least three tablespaces as given here: Catalog tablespace: It contains system catalog tables for the database.