|
View previous topic :: View next topic
|
| Author |
Message |
prasun dhara
New User
Joined: 01 Mar 2008
Posts: 49
Location: kolkata
|
|
|
|
GETPAGE -> 585918 GETPFAIL -> 0
SYNCREAD -> 6079 SPFETCH -> 0
LPFETCH -> 0 DYNPFETCH -> 5813
PFPAGES -> 13447 PAGEUPDT -> 0
From the CA detector I am getting above information for a SQL query.
Can anyone explain what does this figure actually mean (specially GETPAGE , SYNCREAD , DYNPFETCH ) ?
Ex. How many times db2 was hit in this query (how many fetch) ? etc
Thanks
Prasun |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
probably the CA detector manual will explain.
or do you want someone here to read the manual for you? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Or, of you want, CA Support will provide these answers. |
|
| Back to top |
|
|
|
|
