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 |
How does cobol compile db2 program?
What does db2 plan contain?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
On which levels locks can be applied?
what is check point and restart Logic ? why do we go for that ??
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
How can we read records for specific member in CL? AND rpg?
wht displays the number of times a query modified ?
When can an insert of a new primary key value threaten referential integrity?
What does DSNDB07 database do?
what is a trigger and types of triggers
What do you mean by storage group (stogroup)?