RE: how informix archive works?
Hi!
You are experiencing a bug prior to 7.31.UC7. You should upgrade to a later
version of 7.31.
André Déziel
National Bank of Canada
>From: "Simmons, Keith" <keith.simmons@office2office.biz>
>To: ids@iiug.org
>Subject: RE: how informix archive works? [2994] Date: Thu, 20 May 2004
>04:07:00 -0400 (EDT)
>
>Miyaki
>
>I have absolute confidence in the Informix archive. I too back up using
>ontape and have restored (to a test machine) on numerous occasions with no
>problems.
>Do you have some very old data in your database? It could be you are
>encountering the 'archive very old page' bug which slows the archive while
>it updates the timestamp on very old pages. Once they have been updated
>(and
>if there is no other activity on the system) they will not need to be
>updated if you archive again immediately after.
>You do not say what the normal length of time of an archive is, or is this
>the first archive for some days (weeks, months)?
>A bit more information.
>
>Keith
>
>-> -----Original Message-----
>-> From: miyaki [mailto:lcib@yahoo.com]
>-> Sent: Thursday, May 20, 2004 4:27 AM
>-> To: ids@iiug.org; informix-list@iiug.org
>-> Subject: how informix archive works?
>->
>->
>-> Hi all,
>->
>-> I have some doubt on the informix backup. I'm using
>-> ontape command to perform level 0 backup on my Test
>-> database (7.31.UC2). The first level 0 backup took
>-> around 2 hours to complete and the second time of
>-> level 0 backup only took ~45min. The second time of
>-> the backup begin right after the first backup
>-> completed. There's no other transactions running on
>-> the database during the backup. Which means that the
>-> data for both archive is exactly identical. My
>-> question is why second backup take shorter duration to
>-> complete compare to the first backup
>->
>-> Does any one of us know where can i obtain the
>-> documentation to describe how informix archive works?
>->
>-> TIA,
>-> miyaki
>->
>->
>->
>->
>-> __________________________________
>-> Do you Yahoo!?
>-> Yahoo! Domains - Claim yours for only $14.70/year
>-> http://smallbusiness.promotions.yahoo.com/offer
>-> sending to informix-list
>->
>
>
>*******************************************************************************
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be
>disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of
>any
>error in transmission.
>This footnote also confirms that this email message has been swept for the
>presence of computer viruses, however we cannot guarantee that this message
>is free from such problems.
>*******************************************************************************
***
>
>