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 a db2 schema?

764


what is utility for parm lib

1884


Define declaration generator (dclgen).

667


What is a db2 table?

597


What is load replace in db2?

560






How do I start db2 in windows?

567


Outputs of explain are with matchcols = 0. What does this signify?

619


How to get the ddl of a table in db2?

679


What action db2 takes when a program aborts in the middle of a transaction?

659


What is the max length of sqlca?

768


How to find primary key of a table in db2?

615


How do I add a column in db2?

594


How many databases are there?

592


What is the role of schema in the db2 database?

653


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2688