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.
==============================================================================
midrange.com
