Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tuning the SQL queries

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
meenakshi_forum
Warnings : 1

Active User


Joined: 27 May 2008
Posts: 121
Location: India

PostPosted: Fri Jan 29, 2010 6:32 am    Post subject: Tuning the SQL queries
Reply with quote

Hello everybody!

I need to learn about query tuning, please guide me to learn it,
is there any manual for it?

Would appreciate if someone can give me some SQL examples of Query
tuning.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jan 29, 2010 8:24 am    Post subject:
Reply with quote

Hello,

Quote:
is there any manual for it?
Not that i'm aware of.

Tuning a query is much like tuning anything else. Determnine where the resources are being used and reduce this where possible. Sometimes this requires a complete redesign of the query or process as well as database modifications.

Suggest you talk with your dba to learn what is available for you to use to research. There is always EXPLAIN.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Fri Jan 29, 2010 12:25 pm    Post subject: Reply to: Tuning the SQL queries
Reply with quote

Meenakshi,


Google is always your friend. icon_biggrin.gif
Anyways, you can start from here DB2 9 for z/OS Performance Topics


Syam
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Fri Jan 29, 2010 4:43 pm    Post subject:
Reply with quote

Susan Lawson : http://www.db2expert.com/index.php?page=download
especially CA DB2 9 for z/OS Performance Guide Part 1,2 & 3
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 Batch job tuning sgandhla Testing & Performance analysis 0 Fri Mar 24, 2017 9:41 pm
No new posts Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts Performance tuning of Online system bipinpeter All Other Mainframe Topics 2 Thu Nov 26, 2015 2:29 pm
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us