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 |
When Can you be sure that a query will return only one row?
What is ibm db2 database?
Explain what are the various isolation levels possible?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
Explain about mirror activator disk mirroring?
Define buffer pool.
What is the command used by TSO users to invoke DB2?
Mention some fields that are a part of sqlca.
What is referential integrity?
What's The Percentage Free Space ?
Is db2 a mainframe database?
Highlight all the advantages that are attached to a package.