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
What is a db2 schema?
what is utility for parm lib
Define declaration generator (dclgen).
What is a db2 table?
What is load replace in db2?
How do I start db2 in windows?
Outputs of explain are with matchcols = 0. What does this signify?
How to get the ddl of a table in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is the max length of sqlca?
How to find primary key of a table in db2?
How do I add a column in db2?
How many databases are there?
What is the role of schema in the db2 database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?