Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me about Restart logic in DB2.
- 2 Answers
- 7407 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 |
wt is view ? wht r the restrictions for view ?
What is image copy in db2?
What is check constraint. Explain with example.
What is the significance of DB2 free space and what parameters control it?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
why we go for SPUFI for creating tables or for sql queries?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is reorg?
How to find primary key of a table in db2?
What is a bind card?
When DB2 connection fails, will online program work or give errors.
what's the best lock size that you could use when you create a tablespace?
COBOL 
