What is deadlock?
Answers were Sorted based on User's Feedback
Answer / s
Deadlock is a situation where two programs are waiting on
each other's lock to be released.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srikanth
when two applications trying to access the same table that
the table is locked by another table is called deadlock
| Is This Answer Correct ? | 2 Yes | 1 No |
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What action db2 takes when a program aborts in the middle of a transaction?
What is referential integrity?
db2 restart logic ?
When DB2 connection fails, will online program work or give errors.
What is cursor stability in db2?
How can you get the number of rows impacted by the last executed query?
Explain about dbrm.
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is a base table?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the size of a data page?