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

db2 restart logic ?

Question Posted / visu.kanchamreddy


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

Post New Answer

More DB2 Interview Questions

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

What is read-only cursor?

1 Answers  

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

What are packages in db2?

0 Answers  

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

What is the usage of open cursor command?

0 Answers  

How is a typical DB2 batch program executed ?

1 Answers  

Is Cursor exicutable ?

3 Answers   TetraSoft,

What is lock contention?

1 Answers  

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

For more DB2 Interview Questions Click Here
Categories