Articles & Content


D04 - PMRS and more

Topic: 2014 NA

Subtopic: DB2 for LUW

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.