>From what we've gleaned so far, EREP is just 'holding the mirror' and some sort of WAIT is causing the CATALOG REDRIVE and is symptomatic of a tuning opportunity. From a sysprog perspective I'm going to review WLM, DB2 buffer use and device busy. Craig Mullins DB/2 series is great and suggests bad SQL is the root cause of a large percentage of DB2 problems. In a message dated 6/18/2017 1:40:12 A.M. Central Daylight Time, [email protected] writes:
It's been a few years (retired / consulting now) since I had the duty of looking at EREP records but as with what many others have said, it's about what seems "normal" in your environment, although I've had instances of 0C4 that was occuring regularly, though handled by the piece of software in question without killing anything. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
