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

What does the CHECK Utility do ?

1 Answers  

what is a trigger and types of triggers

3 Answers   HSBC,

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

What is a subselect? Is it different from a nested select?

1 Answers  

Explain db2.

0 Answers  




What is package versioning? Please give an example.

1 Answers  

What are column-name qualifiers used?

1 Answers  

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

What is COPY PENDING status?

6 Answers  

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

When will you chose to run RUNSTATS?

1 Answers  

For more DB2 Interview Questions Click Here
Categories