1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

How would you move a tablespace (using STOGROUP) to a
different DASD volume allocated to that tablespace?

Question Posted / guest


How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tabl..

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

Post New Answer

More DB2 Interview Questions

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

What are the contents of dclgen?

0 Answers  

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,




I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

What is meant by the attachment facility?

3 Answers  

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

1 Answers   CSI, CTS,

What is a dbrm in db2?

0 Answers  

What is check constraint in db2?

0 Answers  

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

For more DB2 Interview Questions Click Here
Categories