What are the various locks available?

Answer Posted / satya narayana

Three. 1. mode , 2.size , 3.duration.

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which command is used to remove all rows from a table?

548


What is package in db2 mainframe?

552


Name the lockable units in DB2?

661


What is the clustering index in the db2 database?

580


How can you find out the # of rows updated after an update statement?

633






What is cursor with hold option in db2?

606


Define check constraint.

639


Comment whether the cursor is closed during commit or not.

664


What is the advantage in De-normalizing tables in DB2?

743


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3112


What are the different types of base tables?

580


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

702


What is the maximum number of columns in a db2 table?

714


What is sqlca’s maximum length?

664


What is db2 command?

578