Answer Posted / angoca
Try to change the isolation level. Also, always reserve the
resources in the same order:
For breakfast, first pick cereal and then milk. Do not do
the opposite (milk then cereal), and this will reduce the
deadlock occurencies. They will be block at the first ressource.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Why select is not preferred in embedded sql programs?
Is db2 a programming language?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain dclgen.
What is drop table?
How to compare data between two tables in db2?
What is alias in db2?
What is image copy in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?