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
 

 

Cost of a SQL query using QMF,SPUFI or File Aid for DB2

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

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Thu Oct 16, 2008 6:15 pm    Post subject: Cost of a SQL query using QMF,SPUFI or File Aid for DB2
Reply with quote

Hi All,

I want to know is there any way i can know the cost of a query using QMF,SPUFI or File Aid for DB2.
I know while running in QMF they give the cost but i am not sure what is the unit plus for my query, it is being displayed for micro seconds, so i am not able to figure it out. Secondly, can i say if a query takes 2 sec on a table having 100 rows, then it will take 20 sec if number of rows are 1000.
Actually, the problem is we are asked not to simulate production condition in test as it is costing much. So i want to know is there a way wherein i can say if it is taking this much time in test, then it will approximately take this much time in production.

Lastly, i want to know is there any good document, explaining the way DB2 interprets the where clause and how query will behave in case we use AND,OR,ANY,In etc etc.
Back to top
View user's profile Send private message

acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Thu Oct 16, 2008 6:26 pm    Post subject:
Reply with quote

I would start reading about EXPLAIN.

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.adb.doc.ug/h1xexchap.htm
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
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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