Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Can any one tell me about Restart logic in DB2.

Question Posted / rajesh_m13

Answers were Sorted based on User's Feedback



Can any one tell me about Restart logic in DB2...

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

Can any one tell me about Restart logic in DB2...

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

Post New Answer

More DB2 Interview Questions

What is db2 stogroup?

0 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

What are db2 objects?

0 Answers  

How to access db2 tables in mainframe?

0 Answers  

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

Explain about cursor stability?

0 Answers  

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

What is dbrm?

0 Answers  

For more DB2 Interview Questions Click Here
Categories