Interested to Buy Any Domain ? << Click Here >> for more details...
what is the soft code for deadlock ?
- 2 Answers
- 6967 Views
- Logica CMG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
how to resolve -811 error. give clear explination
how do we solve soc 7 and soc4 ?
What is reorg in database?
What is meant by dclgen?
Give some example of statistics collected during RUNSTATS?
What is cobol db2?
What are the 2 sqlcodes that are returned?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
COBOL 
