Re: RCLSTG *DBXREF

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

If you are doing a RCLSTG *DBXREF, then what you are doing is 
reorganizing the files in QSYS that start with QADB* .  So the best way 
is to check the size of these files, and the number of deleted records 
that they contain.  From the title of this email, I assume you werent 
talking about a full RCLSTG.

   Pete

Mark Allen wrote:

> I know IBM says there is no way to estimate but if anyone has a similar
> config to mine (see below) and has done one I would appreciate how long
> it took.
>
>                                                             05/08/03
> 10:50:55
> % CPU used . . . . . . . :         .9    Auxiliary storage:
>
> % DB capability  . . . . :         .0      System ASP . . . . . . :
> 54.52 G
> Elapsed time . . . . . . :   00:00:01      % system ASP used  . . :
> 76.0058
> Jobs in system . . . . . :       1095      Total  . . . . . . . . :
> 54.52 G
> % perm addresses . . . . :       .013      Current unprotect used :
> 1892 M
> % temp addresses . . . . :       .044      Maximum unprotect  . . :
> 2144 M
>
>
> Type changes (if allowed), press Enter.
>
>
>
> System    Pool    Reserved    Max   -----DB-----  ---Non-DB---
>
>  Pool   Size (M)  Size (M)  Active  Fault  Pages  Fault  Pages
>
>    1      113.15     66.80   +++++     .0     .0     .0     .0
>
>    2      499.37       .33      52     .0     .0     .0     .0
>
>    3        7.67       .00       6     .0     .0     .0     .0
>
>    4      147.78       .00      20     .0     .0    5.2    5.2
>
>
>
>
> Bottom
> Command
>
> ===>
>
> F3=Exit   F4=Prompt           F5=Refresh   F9=Retrieve   F10=Restart  
>
> Memory is 768 MB
>
>                                                            05/08/03
> 10:54:37 
> Elapsed time:   00:00:00
>
>
>
>             Size    %     I/O   Request   Read  Write   Read  Write
> %      
> Unit  Type    (M)  Used    Rqs  Size (K)    Rqs   Rqs     (K)   (K)
> Busy     
>   1  6607   3145  76.2     .0       .0      .0     .0     .0     .0
> 0     
>   2  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   3  6607   4194  76.0     .0       .0      .0     .0     .0     .0
> 0     
>   4  6607   4194  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   5  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   6  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   7  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   8  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>   9  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>  10  6607   3145  75.9     .0       .0      .0     .0     .0     .0
> 0     
>  11  6607   4194  75.9     .0       .0      .0     .0     .0     .0
> 0     
>  12  6607   4194  76.0     .0       .0      .0     .0     .0     .0
> 0     
>  13  6607   4194  75.9     .0       .0      .0     .0     .0     .0
> 0     
>
> More... 
> Command
>
>             Size    %     I/O   Request   Read  Write   Read  Write
> %   
> Unit  Type    (M)  Used    Rqs  Size (K)    Rqs   Rqs     (K)   (K)
> Busy  
>  14  6607   4194  75.9     .0       .0      .0     .0     .0     .0
> 0  
>  15  6607   4194  75.9     .0       .0      .0     .0     .0     .0
> 0  
>
>
>
> Mark Allen
> IS Manager
> Wilkes Telephone & Electric
> 11 W. Court Street
> Washington, GA 30673
> Phone: (706) 678-9565
> Fax: (706) 678-1000
>
>
> _______________________________________________
> 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.cgi/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.
>
> .
>
>