What is the purpose of the QUIESE Utility?
Answer / s
QUIESE establishes a consistency point for a tablespace by
writing all pending updates to DASD and writing the log RBA
to SYSIBM.SYCOPY
| Is This Answer Correct ? | 2 Yes | 0 No |
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What happens to a cursor after a commit?
What are union and union all?
What's the difference between DB2 active log and archive log? Thanks a lot...
what is SMP/E? and what are the major steps of it? thanks...
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is consistency token in db2?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What does db2 plan contain?
what is copy pending and check pending ?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?