Re: How to find largest number of contiguous frames in overflow

"bontemps" <jontan_mlr@[EMAIL PROTECTED]
> wrote in message 
news:d40488ae-a418-4385-819c-a6917ff6e962@[EMAIL PROTECTED]
> USing D3 7.3. Our overflow table has a huge number of blocks making it
> very difficult to determine whether I have enough contiguous frames to
> create very large files. We need to do a full restore but may not be
> able to before having to create some large files. Is there anyway
> besides just creating the file to determine if we have the contigous
> frames?


Overflow options:

a  Lists the start and end fids for each block as well as their sizes.
When 
using the (a option, the user may filter the fids displayed by specifying
a 
high and low limit.  If the (b option is used along with the (a option,
then 
the display will show the block start and end fids plus the sizes, but the

user can filter blocks based on size.

b  Lists total number of frames for each contiguous block of overflow. 
When 
using the (b option, the user may specify a range of sizes as well.

c  Only counts frames which are displayed with the (a or (b options in the

final frame and block counts.

n  (The letter "n") Activates nopage function on output to the terminal.

o  Displays the "old" safe table. Before every full or incremental save,
the 
most significant blocks in the overflow table are saved in an alternate 
area.  This area can be displayed using the (o option.  This option is 
useful for analyzing the change in overflow over a time period.

p  Directs output to the printer, via the Spooler.

s  Displays only "safe" blocks.  The "safe" blocks are blocks that will be

restored in case of a power-loss or full system crash.

t  Displays blocks in the "safe" table with an asterisk.

-- 
Mark Brown
Sr. Software Engineer
Drexel Management Svc Inc.
484-716-6154 (cell)