How does DB2 determine what lock-size to use?

Answers were Sorted based on User's Feedback



How does DB2 determine what lock-size to use?..

Answer / s

LOCKSIZE is defined with the CREATE TABLESPACE DDL.

Is This Answer Correct ?    13 Yes 1 No

How does DB2 determine what lock-size to use?..

Answer / techie

Can anyone of you explain me the below statement.

"A solution used for lock escalation in past jobs have been
to have the jobs take an explicit lock on the partition
which prevents lock escalation."

How do i take lock on the partition level, what would be
the definition for it. I googled but couldnt get any

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


What can the Locate option of the Repair Utility accomplish?

2 Answers  


What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,






What is release/acquire in bind?

0 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


What is db2 isolation?

2 Answers  


What is dbrm? What it contains? When it will be created?

0 Answers  


What is dbrm library?

0 Answers  


What is difference between *omit and *nopass?

1 Answers   IBM, TCS,


Categories