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 |
What technique is used to retrieve data from more than one table in a single SQL statement?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Which command is used to connect to a database in DB2 ? Give the Syntax.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is consistency token in db2?
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?
What is a base table?
Explain how can you do the explain of a dynamic sql statement?
What is bind plan?
What does runstats do in db2?
What is an instance database?