Interested to Buy Any Domain ? << Click Here >> for more details...
what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 5809 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kums
If we specify LOCKSIZE(ANY), DB@ will decide the optimum
locking Mechanism for the best use.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / s
PAGE lock size performs well in most situations. Use Row
level locking if there is lock contentions.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is declare cursor?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is a buffer pool?
What is the advantage in De-normalizing tables in DB2?
What information is contained in a SYSCOPY entry?
Is there any advantage to denormalizing DB2 tables?
How Plan is created while executing the query using SPUFI?
How do you select a row using indexes in db2?
Where do you specify them?
What is dbrm? What it contains?
What is bind package and plan in db2?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
COBOL 
