How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?
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 |
How many databases are there?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is copy pending status in db2?
How do I copy a table in db2?
Return code 100 means?
Discuss about db2 bind?
Explain what are the various isolation levels possible?
How will you return the number of records in table?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What are the three lock types?
Outputs of explain are with matchcols = 0. What does this signify?
What is a DB2 plan?