If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Rows Selected > Rows Read

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-28-10, 11:55
db2udbgirl db2udbgirl is offline
Registered User
 
Join Date: Mar 2006
Location: Tuticorin, India
Posts: 100
Rows Selected > Rows Read

Env : DB2 9.5 / AIX 5.3

I noticed that couple of agents (which has more CPU usage) has the following information on application snapshot

Rows selected = 1022020398
Rows read = 5280
Rows written = 645


But I am not sure how is it possible as rows selected(fetched) is a subset of rows read.

Other related info from the same app snap is as below
Application handle = 8040
Application status = UOW Waiting
Status change time = 10/28/2010 11:43:39.075514
Application code page = 1208
Binds/precompiles attempted = 0
Rows deleted = 0
Rows inserted = 186
Rows updated = 461
Rows selected = 1022020398
Rows read = 5280
Rows written = 645
Most recent operation = Close
Cursor name = SQL_CURSH100C4
Most recent operation start timestamp = 10/28/2010 11:43:39.075150
Most recent operation stop timestamp = 10/28/2010 11:43:39.075493


Pls advice
Reply With Quote
  #2 (permalink)  
Old 10-28-10, 17:50
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I suspect DB2 is most likely doing an index-only to get most of the rows.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On