what is the soft code for deadlock ?

Answers were Sorted based on User's Feedback



what is the soft code for deadlock ?..

Answer / deepthy

-911 and -913 are the sqlcodes for deadlock. But DB2 attempts
to roll back the SQL for one of the application
processes. If the
ROLLBACK is successful, that application receives
SQLCODE -911. If the
ROLLBACK fails, and the application does not abend,
the application
receives SQLCODE -913.

Is This Answer Correct ?    4 Yes 0 No

what is the soft code for deadlock ?..

Answer / suneel reddy

-913

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More DB2 Interview Questions

What is rebind in db2?

1 Answers  


when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


What is auditing?

2 Answers  


What is the purpose of the WHENEVER statement?

1 Answers  


How do I start db2 in windows?

1 Answers  


What is a clustered index?

1 Answers  


What is load utility in db2?

1 Answers  


What is the difference between cursor and select statement?

1 Answers  


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  


Is it possible using max on a char column?

1 Answers  


What do you mean by storage group (stogroup)?

1 Answers  


Categories