Good topic, Jon. Am constantly struggling with high volumes of DB2 SMF records myself. Before dropping them entirely you might consider activating/using DB2's fairly new ACCUMACC parameter whose objective is the consolidation and therefore reduction of DB2 SMF records.
Had asked for opinions/experiences with DSNZPARM ACCUMACC (modifiable on the fly thru ISPF) on MXG-L recently. Got only one response giving numbers (mentioning a reduction factor of 100), so this is a question I wanted to ask from IBM-MAIN as well. Any experiences with ACCUMACC in "IMB-MAIN-land"? To what value have you set it? Any pros and cons? Robert Bardos Ansys AG, Zurich, Switzerland > -----Ursprungliche Nachricht----- > Gesendet: Donnerstag, 1. Marz 2007 14:48 > Betreff: How are you handling high SMF record volume? > > > We are running into issues with the volume of SMF records that we need > to process. We create a GDG every day for that day's records. > Occasionaly we run into contention issues during the day but mostly it > hits us at the end of the day when we read the day's records from the > GDG and split the output into various other tapes for specific functions > (accounting, performance, etc). While that job is reading the many tapes > created during the day, the GDG base is locked so our dump jobs are > forced to wait which eventually causes lost SMF data. > Has anyone else run into this problem? How are other shops handling high > SMF volumes? > We have 4 SMF datasets on each LPAR. Two are 3000 cyl and two are 1500 > cyl. > A side issue is that we are capturing DB2 trace records in SMF. We have > tried to turn them off but our performance area 'needs' them. We would > like to move these records from SMF to GTF but we use MXG and were told > that MXG cannot handle input from GTF. Any ideas? Is anyone using MXG > with GTF input? > Thanks much for any help! > Jon > > Jon L. Veilleux ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
