Re: On-Archive

Rick Ward wrote: > > Using: ONLINE DSA V7.13.UC2 > > Can anyone out there let me know if they use on-archive, how they have found it, and give me an > idea for a simple strategy to archive a 10Gb DSS database into files on disk of less than 2GB > each. > > Thanks, > > -- > Rick Ward > Senior DBA > Great Universal Stores Home Shopping > MANCHESTER, UK I'm using it. Not very impressed, really. It's quite flaky, prone to errors in the catalog which require a catalog re-build. Also, you seem to have to duplicate the definitions the locations of your disk storage, as it requires referencing in both the $ARC_CONFIG file, and the onarchive volume definition. Having said all that, now I've got on top of it it's running fairly smoothly. You don't have to worry about an archive spreading over more than one file system, it'll handle that, so you need only worry about the 2GByte limit if you're actually short of disk space. If so, you'll want to use the facility that allows you to define a "dbspaceset" - a set of dbspaces to comprise the archive. Of course, if the size of the archive of any one of your dbspaces exceeds the amount of disk storage you have, you're .... in trouble! Hope this helps. Call if you want to know more. Neil Truby Chase Manhattan Bank Bournemouth Tel: 01202 341615