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


Please Help Members By Posting Answers For Below Questions

What is the use of db2 optimizer?

608


what is the role of the cursor in db2?

639


Explain package in db2 and its advantages?

593


what is a corelated subquerry?

658


Define check constraint.

642






What is declare cursor?

610


What is a db2 schema?

760


What are db2 tables?

645


What is explain plan in db2?

588


What is a system catalog table in db2?

586


Explain about cursor stability?

621


What is the meaning concurrency in the db2 database?

631


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?

7507


How do I import a csv file into db2?

558


How would the varchar column remarks defined?

635