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 DB2 query

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pradyutonnet
Currently Banned

New User


Joined: 13 Nov 2005
Posts: 29
Location: pune,mumbai

PostPosted: Fri Jul 15, 2011 1:25 pm    Post subject: cost of a DB2 query
Reply with quote

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.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jul 15, 2011 1:53 pm    Post subject:
Reply with quote

take a look at the DSN_STATEMENT Table.
it is described in detail in every SQL Reference from vsn 7.
how to create, populate and read using spufi.

Quote:
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.


sure you can say that, but it displays a lack of understanding of db2
(as well as computers) that can not be improved by a website forum discussion.

suggest that you start reading - google - ibm websites - developerworks, ibm db2 websites.


IBM self study courses

developerworks information management

DB2 On Campus Videos

we are more than happy to provide answers to specific questions,
not provide general education.
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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


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