Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of PAGE level lock?
- 3 Answers
- 8512 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Less concurrency. Lock contention occurs when an
application program is trying to acquire a lock that is
already held by another program.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / thomas john
high resource utilization when large updates are to be done
| Is This Answer Correct ? | 2 Yes | 2 No |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the difference between TYPE 1 index & TYPE 2 index
How to resolve -502 sql code in DB2?
how do u update the faltfile into db2 table ?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is a result table?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is a subselect? Is it different from a nested select?
What is ALTER ?
What is a trigger in the db2 database?
What is a dbrm in db2?
COBOL 
