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
- 5940 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
Differentiate between cs and rr isolation levels? Where do you specify them?
List down the types of triggers in the db2 database?
How do I optimize a query in db2?
Mention the different locking levels that are available in db2.
What is buffer pool?
Can there be more than one cursor open for any program?
If I have a view which is a join of two or more tables, can this view be updateable?
How do you stop a db2 database in linux?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Who uses db2?
What is a db2 schema?
How do you find the maximum value in a column in db2?
How to find schema of a table in db2?
What is the default page size of buffer pools?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
