what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 4841 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 |
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is rct?
How do I delete a table in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is the significance of DB2 free space and what parameters control it?
How would you find out the total number of rows in a db2 table?
What is rebind in db2?
What is query_cache_limit?
How do I delete a column in db2?
what is + sign and -ve sign for sql code ?
Explain the use of the WHERE clause.
COBOL 
