How would you move a tablespace (using STOGROUP) to a different DASD volume al

How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?

Question Posted / guest

1 Answers
5939 Views
I also Faced
E-Mail Answers

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tabl..

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

More DB2 Interview Questions

How to resolve -917 sql code in DB2?

3 Answers Cap Gemini,

How does one remove entries from the SCT02 table?

1 Answers

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

i have a db2 variable how do u declare tht into working storage section ?

1 Answers TCS,

How to test SQL -911 error while developing COB-DB2 program

1 Answers Satyam,

How to find schema of a table in db2?

0 Answers

What is the usage of open cursor command?

0 Answers

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers IBM,

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers

wht steps we need will coding cobol and db2 pgm ?

6 Answers CGI,

What is an alias and how does it differ from a synonym?

3 Answers

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers MCN Solutions,

For more DB2 Interview Questions Click Here