View previous topic :: View next topic
|
Author |
Message |
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 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? |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
I'm not a DBA either, but I believe that you'd run REORG and RUNSTATS on the desired table spaces, then re-bind packages and plans using the tables in those table spaces. |
|
Back to top |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
Thanks a lot! That's a good place to start looking. |
|
Back to top |
|
|
|