How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?
Answer / s
ALTER STOGROUP
ADD VOLUMES (VOL1)
REMOVE VLUMES (VOL2)
Next time when you do REORG, LOAD replace, RECOVER the
tablespaces will be defined in the new volume added.
| Is This Answer Correct ? | 2 Yes | 0 No |
Mention the different locking levels that are available in db2.
Define db2 and its databases?
What is the usage of open cursor command?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
what is the maximum number of tables that can be joined ?
Is db2 a database?
Differentiate between cs and rr isolation levels? Where do you specify them?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Mention data types used in db2 ?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is collection in db2 bind?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.