RE: members in a file

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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