What is lock contention?
Answer / s
Lock contention occurs when an application program is
trying to acquire a lock that is held by another
application program.
Is This Answer Correct ? | 0 Yes | 0 No |
What is dpf in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Why do we bind in db2?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is Reorg Recovery? when will you run it?
What is cursor stability in db2?
Explain about rct 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?
What is the difference between base table and view?
Explain correlated sub-queries.
what is the sqlcode -501