What is tablespace?
Answers were Sorted based on User's Feedback
Answer / kathir
Tablespace is the collection of tables.we can create
tablespaces by using 3 types,
simple tablespace
sigmented tablespace
partitioned tablespace
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s
Tablespaces are number of VSAM Linear Datasets that store
data for tables and indexes.
| Is This Answer Correct ? | 1 Yes | 0 No |
Before you give the explain statement, what are the prerogatives?
What is a view? Why use it?
What is bind plan?
How to connect to db2 database from windows command line?
What is a LIKE table and how is it created?
What are the uses of db2 optimizer?
What are the various data types available in db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
Which component is responsible for db2 startup and shutdown?
Where would you find information about the type of database authority held by the user?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?