What are the various locking levels available?

Answer Posted / sadiq afroze

PAGE, TABLE, TABLESPACE

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the physical storage length of timestamp data type?

646


What does db2 plan contain?

573


can we view the access paths created by dbrm ? how ? thx

6262


What is the usage of open cursor command?

601


What is collection in db2 bind?

579






Mention the downsides of page level lock.

711


Explain about mirror activator disk mirroring?

560


List some fields from sqlca?

613


What is buffer pool in the db2 database?

621


How do I add a column to an existing table in db2?

592


How to test SQL -911 error while developing COB-DB2 program

6721


What is temporal table in db2?

605


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3797


What are the bind parameters ibm db2?

624


How to view db2 table structure?

595