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:mariobehring AT YAHOO DOT COM]
Sent: den 20 mars 2003 15:33
To: ADSM-L AT VM.MARIST DOT EDU
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
<niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE> 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:mariobehring AT YAHOO DOT COM]
Sent: den 20 mars 2003 14:39
To: ADSM-L AT VM.MARIST DOT EDU
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!