what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 4849 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why do we bind in db2?
What is explain plan in db2?
What are the uses of db2 optimizer?
What do you mean by commit and rollback?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to create db2 table in mainframe?
How do I connect my db2 database to ibm?
What is db2? Explain.
What is the clustering index in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Name the lockable units in DB2?
Define check constraint.
What is the use of db2 optimizer?
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 ?...
What is a system catalog table in db2?
