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 |
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Why do we need reorg in db2?
What are concurrency issues?
What are the Isolation levels possible ?
What will the DB2 optimizer do?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is usage pointer in cobol?
Explain packages.
How do you define a correlated name?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
Define db2 and its databases?