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