dbarchive.vbs Written by Charles Rutledge Copyright (c) 2005 Centauri Computer Works Included are two VBScript programs designed to automate the Informix ontape archive process so it can be run unattended either from a command prompt window or by a script. They are primarily for archiving an Informix database to a disk file but will work just as well for a tape archive PROVIDED that the archive fits on a single tape. There is no provision in the program to prompt an operator to change tapes and a multi-tape archive is untested and will result in unpredictable results. You have been warned. These program are for supporting Informix database servers running under Windows NT/2000 and require Windows Script Host Version 5.6 or latter, which is available from Microsoft at http://msdn.microsoft.com/scripting. Version 1.00 of the program simply automates the archive to the TAPEDEV specified in the ONCONFIG file. It makes no attempt to protect a previous archive file and will happily overwrite it. Version 1.50 not only automates the archive but renames the archive file to prevent it from being overwritten on a subsequent archive and will optionally compress the archive using bzip2. The program is smart enough to realize if this is a tape archive and will silently skip renaming the archive file and compressing it. During the archive and compression, a progress dot is printed every 10 seconds to give you that warm fuzzy feeling that something is indeed happening. The compression option requires that you install the GNU Win32 bzip2 utility, which is available as a free download from http://gnuwin32.sourceforge.net/packages/bzip2.htm. It must be installed in the default directory of "C:\Program Files\GnuWin32\bin". I have found that compression will reduce the size of the archive file by as much as 90% but can take up to four times longer than the actual archive to complete. Your milage may vary. Each program includes the user file and notes for using the program. It's recommended that you rename the program you want to use as dbarchive.vbs, though you can rename it to whatever you like as long as you keep the file extension .vbs as it's required by the Windows Script Host. -------------------------------------------------------------------------------------------------- These programs are licensed under the terms of the GNU General Public License, Version 2 (or at your option, any later version) as published by the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston MA 02111. An copy of this license is available for viewing and download at http://www.gnu.org/copyleft/gpl.html. THIS SOFTWARE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. YOU ASSUME ALL RISKS FOR THE USE OF THIS PROGRAM. -------------------------------------------------------------------------------------------------- These programs were developed by Centauri Computer Works to assist with Informix administration. Support for these programs, should you require it, as well as other services, is available from Centauri Computer Works. Send an email to support@ccwsoftware.com for more information.