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
5872 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

Is db2 free?

1100

What is bind in db2?

1055

What is table space in db2?

1025

What is nvl in db2?

1103

List some fields from sqlca?

1061

What is the use of db2?

1060

Explain about mirror activator disk mirroring?

1018

How can you find out the # of rows updated after an update statement?

1116

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2334

Why select is not preferred in embedded sql programs?

1307

How to resolve deadlock issue

20153

How many types of page locks can be held in db2?

1044

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1275

What is db2 look?

1031

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1111