what is the soft code for deadlock ?
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 |
What information is held in SYSIBM.SYSCOPY?
What is table space in db2?
What techniques will be used to avoid deadlock??
What is the difference between bind and rebind in db2?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How can you count the number of rows from a table tab?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the syntax required for the creation of a cursor?
How do I add a column in db2?
Give the COBOL definition of a VARCHAR field.