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...


How do I handle -911 (deadlock) error in a db2 program so
that the program will never abend?

Answers were Sorted based on User's Feedback



How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?..

Answer / kcs

Naidu,

Please go thru the qns before answering.Everyone knows that
it has to be restarted.
Qns here is how do you handle it in the program so that it
will never abend with deadlock.

Is This Answer Correct ?    0 Yes 0 No

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?..

Answer / naidu sekhar yandrapu

-911 ABEND DEDLCOK WITH TIMEOUT

SOL: RESTART JOB AFTER SOME TIME

Is This Answer Correct ?    2 Yes 4 No

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?..

Answer / sireesha

Dead lock time out erro occurs in the following case:
If two or more programs acquired exclusive lock on the
data,which may be needed for other programs without that
data which can not proceed further.

Solution: You can roll back current unit of work for one of
the programs after preset time interval for deadlocks and
terminate that program.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB2 Interview Questions

What is usage pointer in cobol?

3 Answers   IBM,


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


pls tell me abt the normalization five types....

2 Answers  


What is a predicate?

1 Answers  


Can SQL statements/queries be included in a copybook?

2 Answers  


What is cursor in dbms?

0 Answers  


What is correlation names?

1 Answers  


what is datacom db?

2 Answers   CSC,


What is the use of dclgen in db2?

0 Answers  


What is meant by union and union all?

0 Answers  


what is plan? is plan executable or package?

4 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


Categories