|
How would you move a tablespace to a different DASD volume allocated to that tablespace?
DB2 ( IBM Database 2 ) Interview Questions
(Continued from previous question...)
How would you move a tablespace to a different DASD volume allocated to that tablespace?
Q: How would you move a tablespace ( using STOGROUP ) to a different DASD volume allocated to that tablespace?
Answer:
If the tablespace used is only allocated do that STOGROUP :
ALTER STOGROUP- add volume (new ) delete volume (old )
- REORG TABLESPACE or RECOVER TABLESPACE
Create a new STOGROUP that points to the new volume. ALTER the tablespace and REORG or RECOVER the tablespace.
(Continued on next question...)
Other Interview Questions
| 