ALTER STOGROUP ADD VOLUMES (VOL1) REMOVE VLUMES (VOL2) Next time when

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

Question Posted / s

1 Answers
5766 Views
I also Faced
E-Mail Answers

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 sqlcode -501

12926

How to fetch the last row from the table in SQL (db2)?

1590

How to check last update on table in db2?

1004

What is buffer pool in the db2 database?

1047

What is the role of schema in the db2 database?

1183

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

993

Which component is responsible for processing sql statements and selecting access paths?

1074

Define db2.

1067

What is temporal table in db2?

990

What is db2 stogroup?

1095

How do you pull up a query which was previously saved in qmf?

1100

What is db2 catalog database?

988

Which component is used to execute the sql statements?

1055

How to run db2 command in windows?

1141

What kind of database is db2?

977