Joined: 13 Jun 2012 Posts: 94 Location: United States
I don't know where to look for this, or even if I have got this terminology correct. But, I recall DBAs using log data to improve SQL performance a few years ago. But, I lost my job at that company in the Great Recession.
I now work for a small software development firm and we have a mainframe where I'm trying to duplicate a reasonable DB2 environment for doing tests of our software products and tools. We don't have a DBA or dedicated support staff. I'm pretty well it! I can usually muddle my way through if I get steered in the right direction. Since it's a dedicated environment, screwing things up doesn't hurt anything, I just have to fix it.
So, if anyone can tell me where to go, or tell me I'm crazy and there is no such thing, I'd appreciate it. I believe it may be related to RUNSTATS?