Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 history to optimize SQL path?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


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

PostPosted: Tue Jun 25, 2013 7:56 pm    Post subject: DB2 history to optimize SQL path?
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: 1777
Location: Bloomington, IL

PostPosted: Tue Jun 25, 2013 8:11 pm    Post subject:
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

New User


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

PostPosted: Tue Jun 25, 2013 8:26 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Can we use OPTIMIZE FOR 1 ROWS for fe... cvijay784 DB2 1 Fri Aug 05, 2016 11:56 am
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us