IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 history to optimize SQL path?


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
John Poulakos

Active User


Joined: 13 Jun 2012
Posts: 180
Location: United States

PostPosted: Tue Jun 25, 2013 7:56 pm
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Tue Jun 25, 2013 8:11 pm
Reply with quote

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
View user's profile Send private message
John Poulakos

Active User


Joined: 13 Jun 2012
Posts: 180
Location: United States

PostPosted: Tue Jun 25, 2013 8:26 pm
Reply with quote

Thanks a lot! That's a good place to start looking.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts SYSIBM Catlog tables to see DDL chang... DB2 2
No new posts Optimize sort inrec parse DFSORT/ICETOOL 6
No new posts Detailed Transaction History report f... CICS 5
No new posts Can we use OPTIMIZE FOR 1 ROWS for fe... DB2 1
No new posts Daily report to be extracted from CA ... DFSORT/ICETOOL 5

Back to Top