How does DB2 determine what lock-size to use?
Answers were Sorted based on User's Feedback
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 |
What is bind package and plan in db2?
How to rename a table in DB2 ?
What is the connection string to connect to the DB2 Database ?
how to fetch multiple records without using cursor
B37 abend during spufi?
How do we specify index to include or not during bind process.
Describe major components of db2?
How to view db2 table structure?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Comment whether the cursor is closed during commit or not.
What is a result table?