How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of db2 optimizer?
what is the role of the cursor in db2?
Explain package in db2 and its advantages?
what is a corelated subquerry?
Define check constraint.
What is declare cursor?
What is a db2 schema?
What are db2 tables?
What is explain plan in db2?
What is a system catalog table in db2?
Explain about cursor stability?
What is the meaning concurrency in the db2 database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I import a csv file into db2?
How would the varchar column remarks defined?