Articles & Content

Archives

D04 - PMRS and more

Topic: DB2 for LUW

Subtopic: 2014



Lock: issues/ how to track/how to identify/how to resolve/more abnout rid etc.
Transaction LOG: max-log/num_log_span for concurrency control, impact on system capacity / usage for DR
Trace: use db2 trace and linux strace to identify a slow IO issue
MDC: how to resolve a slow MDC insert issue
LBAC and column mask: pros and cons, how do we use LBAC to protect sensitive data
Careful reading: I try share several tricky thing well documented in DB2 but sometimes not pay attention to.

** Attached is a pptx I started but not finished yet, please take a look and any suggestions are highly appreciated.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.