Answer Posted / nag(igate)
They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the clustering index in the db2 database?
What is temporal table in db2?
Can we delete records from view?
What is cloudant database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is universal database?
What is the role of data manager in the db2 database?
What is the difference between oracle and db2?
How can you find out the # of rows updated after an update statement?
How to check last update on table in db2?
What are the prerogatives?
How to compare data between two tables in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What happens in bind step in a db2 program?
List down the data types in the db2 database.