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: 6968
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 Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am


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