
Sign up to save your podcasts
Or
Here are the show notes for Episode 12 "Baker's Dozen". The show is called "Baker's Dozen" because it is the thirteenth episode, after starting at Episode #0.
Our "Mainframe" topic discussed some fun small enhancements Marna has enjoyed from GRS.
Now, you can get all your "monitoring" into SMF records for both ENQ/DEQs and global generic queue scans. And you don't need to use the cumbersome ISGAUDIT anymore.
Martin talked about coupling facility structure performance, especially as it concerns DB2 lock and cache structures. Having a lot of structures isn't a problem, as long as you are looking at how "busy" the coupling facility is - both CPU- and memory-wise. Sorting in descending order the structures by a metric you want is an important and easy way to figure out which structures to pay attention to.
Balance this with the number of DB2 structures to manage - perhaps hundreds! Some advice was given as to what were the most important metrics to concentrate on.
Looking at "false contentions" and "XES contention" for lock structures is important, and may indicate that these structures need to be larger. Especially if the number of false contentions is high, relative to the lock structure requests. For cache structures, there are different metrics. You may have gotten a large number of structures because you are using DB2 data sharing. Look at names and types for a clue as to where they came from.
Our podcast "Topics" topic is how the audio for this podcast gets produced. If you are interested in audio editing, here are some items that recording this podcast has uncovered:
You can reach Marna on Twitter as mwalle and by email.
You can reach Martin on Twitter as martinpacker and by email and blogs at blog.
Here are the show notes for Episode 12 "Baker's Dozen". The show is called "Baker's Dozen" because it is the thirteenth episode, after starting at Episode #0.
Our "Mainframe" topic discussed some fun small enhancements Marna has enjoyed from GRS.
Now, you can get all your "monitoring" into SMF records for both ENQ/DEQs and global generic queue scans. And you don't need to use the cumbersome ISGAUDIT anymore.
Martin talked about coupling facility structure performance, especially as it concerns DB2 lock and cache structures. Having a lot of structures isn't a problem, as long as you are looking at how "busy" the coupling facility is - both CPU- and memory-wise. Sorting in descending order the structures by a metric you want is an important and easy way to figure out which structures to pay attention to.
Balance this with the number of DB2 structures to manage - perhaps hundreds! Some advice was given as to what were the most important metrics to concentrate on.
Looking at "false contentions" and "XES contention" for lock structures is important, and may indicate that these structures need to be larger. Especially if the number of false contentions is high, relative to the lock structure requests. For cache structures, there are different metrics. You may have gotten a large number of structures because you are using DB2 data sharing. Look at names and types for a clue as to where they came from.
Our podcast "Topics" topic is how the audio for this podcast gets produced. If you are interested in audio editing, here are some items that recording this podcast has uncovered:
You can reach Marna on Twitter as mwalle and by email.
You can reach Martin on Twitter as martinpacker and by email and blogs at blog.