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 |
What is a clustering index?
Why cursor is used in db2?
How can you split a table in to exactly half?
What is an intent lock?
Can you define an Index if the table size less than 10 PAGES?
What is role in db2?
What is dbrm? What it contains? When it will be created?
Is there any advantage to denormalizing DB2 tables?
Give a brief description of db2 isolation levels?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is a cursor and what is its function?
What are the abend codes occour in ur latest PROJECT in DB2