Can any one tell me about Restart logic in DB2.
- 2 Answers
- 6362 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girish kumar
suppose if we have 1000 rows for update, while we updating
incase if we get abend occures at 999 even a single record
could not be saved to database with out execute commit.
so that if we can place a commit for every 100 records
incase abend occres at 999 cursor start for 900 onwords by
issuing rollback along with commit.
this is db2 logic better to refer MUTTU REFRESHNER
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / muneer
suppose if we have 1000 records while retriving data we got
abend at any stage we will use restart logic.this is the
basic idea of restart logic...
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the command used by TSO users to invoke DB2?
What is the role of the data page in the db2 database?
How do I import a csv file into db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is an intent lock?
What will the FREE command do to a plan?
Is ibm db2 free?
What is cascading rollback?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is the syntax for creating a table in the db2 database?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
what is a collection?
COBOL 
