Been running into an interesting trend in working on different systems, looking for performance issues, finding things that need to be addressed. Typically it all starts with a client that is confused about the performance they’re seeing after an upgrade that was supposed to fix everything automagically, but doesn’t seem to have accomplished that once completed. There are many, many […]
Tag: tuning
Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 3)
Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 3) Utility Execution Information If you are charged with running (IBM) DB2 utilities, another useful command is DISPLAY UTILITY. Issuing a DISPLAY UTILITY command will cause DB2 to display the status of all active, stopped, or terminating utilities. So, if you are in over the weekend running REORGs,...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 2)
Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 2) Of course, there are many additional options that can be used in conjunction with the DISPLAY DATABASE command. The following options can be used to narrow down the amount of information displayed: USE displays what processes are using resources for the page sets in the database CLAIMERS...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here