db2 restart logic ?
Answer / ankitha
declare temp table with fields pkey and commit frequency.
then set commit frequency ie after 100 records it should
tabulate the temp table and in procerdure division read the
last pk value and should start updating after that pk value
and should delete this temp tble after the final commit or
stop run.
Is This Answer Correct ? | 13 Yes | 1 No |
Which command is used to remove all rows from a table?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain packages.
Why select is not preferred in embedded sql programs?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Is db2 a mainframe?
Explain the use of the WHERE clause?
What is an asychronous write?
Why cursor is used in db2?
What is a cursor and what is its function?
What is lock contention?