Hello
I'm not an Informix dba either...But it's pretty straigt forward This is the backupcommand that we run as a preschedulercommand: onmode -uy shutdown of database ontape -s -L 0 < E:\server\scripts\enter.txt When you run ontape you have to press enter, the enter.txt files contain one enter onmode -m starts the database There are more cmdfiles involved since we are renaming the backupfiles and moves them to another directory because the backup always goes to the same file, backup.bup, and to save the backup you have to copy and rename that file. The onconfig looks like this: # System Archive Tape Device #TAPEDEV \\.\TAPE0 # Tape device path TAPEDEV L:\Backserv\Backup.bup # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 2000000 # Maximum amount of data to put on tape (Kbytes) We used to run onbar but the dba wanted to restore single tables and to do that you had to shutdown the database and run ontape , don't ask me why it couldn't be done with onbar.. Regards Niklas -----Original Message----- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 15:33 To: [EMAIL PROTECTED] Subject: Re: Informix backup Hi Niklas, Can you be more specific ? What is this preschedule command you use ? Sorry, I am no Informix DBA. Thanks. Best regards, Mario Niklas Lundstrom <[EMAIL PROTECTED]> wrote:Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -----Original Message----- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario --------------------------------- Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! --------------------------------- Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!