Re: onarchive question (fwd)
Had to send to Informix List since I can not e-mail you directly.
---------- Forwarded message ----------
Date: Mon, 22 Apr 1996 07:31:54 -0500 (CDT)
From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov>
To: Eric Sze <erics@imu.msmail.cuhk.edu.hk>
Cc: "Informix:R Cruz" <RFJE49A@prodigy.com>
Subject: Re: onarchive question
Sorry Eric
I have not used onarchive at all. I have been staying away from it
onarchive (earlier comments in the Informix-List). It seems to have all
kinds of problems. I use ontape
Have a Good Day
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
OR
cherylk@spamis.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Mon, 22 Apr 1996, Eric Sze wrote:
}
} Sorry to interrupt you.
}
} I have a few question about using informix onarchive to perform database
} backup.
} I know you are expert of informix, can you help me ?
}
} If I have setup volume set :LOGTAP with 3 tapes labelled LOGT1, LOGT2,
} LOGT3.
} and DBTAP with 3 tapes labelled DBT1, DBT2, DBT3. All tape expiry date is
} set to 1 day only.
} Everyday, I will use a DBTAP (archive database) tape and LOGTAP (logical
} log) tape.
} my archive command: onarchive
} 'archive/dbspaceset=*/vset=DBTAP/apart/level=0'
} my backup command: onarchive
} 'backup/logfile/continuous/nocurrent/vset=LOGTAP/expiry_date=0001-00:00:00'
}
} Q1. After all tapes in volume set DBTAP is used, the archive command prompt
} me to define a new volume.
} How can I reuse the old tapes (eg. DBT1) instead of adding a new volume to
} this volume set ?
}
} Q2. When I read the online.sapdev.id2.log message to monitor my backup
} logical log command, I found that the backup can automatically start when a
} new logically log is created. However, it will not automatically backup
} complete until I press ctrl+c. It seen different from ontape command 'ontape
} -c'.
} Is it normal ?
}
} Hardware :IBM RS/6000 AIX 4.1
} DataBase: SAP/R3 version 2.2E under Informix 6.0
}
} Thanks a lot!
} EricSze
} ericsze@cuhk,edu.hk
}