How would you move a tablespace to a different D

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
• What is the best lock size that you could use when you create a tablespace?
• What is RUNSTATS?
• How to see the structure of DB2 table?
• What is read-only cursor?
• What is the SQL Communicaions Area and what are some of its key fields?
• What is EXPLAIN?
• What is SKELETON cursor table (SKCT?
• What is meant by concurrency?
• What is the difference between IN subselects and EXISTS subselect?
• More...