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 do you mean by NOT NULL? When will you use it?
Explain in detail about buffer manager and its functionalities?
What is node in db2?
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?
What is the maximum length of sqlca?
What is a synonym ?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
Explain the benefits you can get from mainframe connect?
what are stage one indexable predicates?
What are db2 objects?