How can you move a tablespace to a different DASD volume allocated to

1.	How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?
Answer» The method to move the TABLESPACE to a different DASD volume ALLOCATED to that tablespace is: ALTER STOGROUP - ADD VOLUME (new volume) DELETE VOLUME (old volume) REORG TABLESPACE or RECOVER TABLESPACE So, BASICALLY, the method is that we create a new STOGROUP that points to the new volume and ALTER the tablespace and REORG or RECOVER the tablespace.

How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?

Answer»

The method to move the TABLESPACE to a different DASD volume ALLOCATED to that tablespace is:

ALTER STOGROUP - ADD VOLUME (new volume) DELETE VOLUME (old volume)

REORG TABLESPACE or RECOVER TABLESPACE

So, BASICALLY, the method is that we create a new STOGROUP that points to the new volume and ALTER the tablespace and REORG or RECOVER the tablespace.

Discussion

No Comment Found

Related InterviewSolutions

How is INNER JOIN different from simply writing a JOIN?
What is DCLGEN in DB2?
As you know there are different sizes of locks. Can you tell how DB2 decides which lock size should be used?
What are the two levels of isolation and what is the major difference between the 2 levels?
How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?
What is MAX in DB2? Is it possible to use MAX in a CHAR column?
What is a CURSOR and What is the use of it?
What is concurrency in terms of DB2?
What are UNION and UNION ALL in DB2? How do you differentiate between them?
What is the difference between the above two queries i.e. DELETE and DROP?

How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment