IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

cost of a DB2 query


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts RACF cost vs. ACF2 cost IBM Tools 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
Search our Forums:

Back to Top