Re: Trim Snapshot Files in Rdb 4.1

I believe that you probably can use the SQL statement ALTER DATABASE ... ALTER STORAGE AREA ... SNAPSHOT ALLOCATION IS ... (though I'll admit that my rdb 4.1 memory is rather antique)

But you should understand that doing this is simply forcing the application to run slower. The snapshot files extend because they need to (due likely to long running transactions in the system). So forcing them to extend every week will probably only slow things down in the long run unless you are able to determine that the long running transactions are unneeded and are able to repair/resolve them.

Craig Dedo wrote:
> We are running several older applications using Rdb/VMS 4.1 under VMS
> 5.5-2. Up until now, we have not had to worry about the amount of
> disk space that the Rdb snapshot files were taking up. Now, this is
> no longer the case.
>
> How do you trim the Rdb snapshot files back to their originally
> specified size? I already looked in the Rdb/VMS 4.1 Guide to Database
> Maintenance and several other Rdb/VMS 4.1 reference manuals and I
> could not find any information about how to perform this operation.
>
> I would like to trim the snapshot files back to 100 blocks per
> file on a weekly basis, as part of the weekly full backup job.
>
> Sincerely,
> Craig T. Dedo, VMS Consultant
> Dept. 30G, Bldg. AP8B-3
> Abbott Diagnostics Division - Abbott Laboratories
> 100 Abbott Park Road
> Abbott Park, IL 60064-6041
> Voice: (847) 938-0144 Fax: (847) 938-5003
> E-mail: Craig.Dedo_at_abbott.com

-- 
norman lastovica / oracle rdb engineering / usa / 610.696.4685