RE: members in a file

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

Thanks to all for helping me....  I will check back tomorrow to see if any new ideas were spawned..

Thanks, tim

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, December 27, 2007 1:59 PM
To: Midrange Systems Technical Discussion
Subject: RE: members in a file

mañana

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/27/2007 04:45 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: members in a file






I did a DSPFD on that SQL view.  It appears to be using some sort of a
UDTF
in the FROM clause.  I suspect UDTF code is hanging.
Time to call IBM.

Elvis

Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: RE: members in a file

1 hour later, still running and running and running...
smaller lpar
% CPU used . . . . . . . :        7.4
System ASP . . . . . . :    917.3 G
% system ASP used  . . :    57.9751
System    Pool    Reserved    Max   -----DB-----  ---Non-DB---
 Pool   Size (M)  Size (M)  Active  Fault  Pages  Fault  Pages
   1     2015.42    246.66   +++++     .0     .0   14.6   14.6
   2     1998.65     24.63     494    1.6    2.5  114.5  359.2
   3      101.96       .05      15     .0     .0     .0     .0
   4     4551.05       .03     383  152.8  152.8   75.6   78.2
   5     1529.47       .00     117     .0     .0     .0     .0

               Size    %     I/O   Request   Read  Write   Read  Write %
Unit  Type      (M)  Used    Rqs  Size (K)    Rqs   Rqs     (K)   (K) Busy
   1  4328   141129  57.9   37.1      6.4    30.7    6.4    5.3   11.9 5
   2  4328   105847  57.9   30.8      6.3    26.9    3.9    5.1   14.7 23
   3  4328   105847  57.9   25.9      4.6    25.8     .1    4.6    4.0 11
   4  4328   105847  57.9   28.5      4.8    27.6     .9    4.6   12.5 23
   5  4328   105847  57.9   31.2      4.7    28.0    3.2    4.1   10.1 11
   6  4328   141129  57.9   40.7      4.7    38.3    2.4    4.3   11.2 29
   7  4327    52923  57.9   15.5      4.7    14.9     .5    4.5    8.0 29
   8  4327    52923  57.9   14.7      4.8    14.3     .3    4.7    9.3 5
   9  4327    52923  57.9   18.2      4.4    17.9     .3    4.4    5.3 5
  10  4327    52923  57.9   17.4      4.6    16.9     .5    4.5    6.4 5


Rob Berendt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain 
confidential or privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the 
sender by reply e-mail and destroy the message.


==============================================================================