Interested to Buy Any Domain ? << Click Here >> for more details...
How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?
- 1 Answers
- 5794 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What's the maximum number of volumes that can be added to a STOGROUP?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is the difference between nvl and coalesce?
What is difference between rollback and commit?
Where is the output of EXPLAIN stored?
What is a synonym? How is it used?
What are the two types of logging in the db2 database? Explain them.
What is the physical storage length of date data type?
How do I import data from excel to db2?
Explain how can you do the explain of a dynamic sql statement?
What is concurrency in db2?
What is a view? Why use it?
COBOL 
