system info: HP rp7410; OS B.11.11 (11iv1); IDS 9.40.HC3

We have a live, live_audit & train db; the live has about 20 tables we
use trigger audits to write audits to our live_audit db.

These been a process to move our live db to our train db using
onunload and onload using tape and have been using it for about 4-5
years without any problems.

script 1 does a :
/opt/informix/bin/onunload -t $tape livedb {where $tape is defines in
script as one of our tape drives)

script 2 does a :
/opt/informix/bin/onload -t $tape -d dbs0 traindb {same $tape coding}

This weekend I ran the process an some how for the first time the
train db is now writing audits to the live_audit db.

Anyone have have a clue why, as this process has been working for
years?

John

jda wrote:
> system info: HP rp7410; OS B.11.11 (11iv1); IDS 9.40.HC3
>
> We have a live, live_audit & train db; the live has about 20 tables we
> use trigger audits to write audits to our live_audit db.
>
> These been a process to move our live db to our train db using
> onunload and onload using tape and have been using it for about 4-5
> years without any problems.
>
> script 1 does a :
> /opt/informix/bin/onunload -t $tape livedb {where $tape is defines in
> script as one of our tape drives)
>
> script 2 does a :
> /opt/informix/bin/onload -t $tape -d dbs0 traindb {same $tape coding}
>
> This weekend I ran the process an some how for the first time the
> train db is now writing audits to the live_audit db.
>
> Anyone have have a clue why, as this process has been working for
> years?
>
> John

Ok, let me make sure I have this straight . . .

triggers on livedb --> live_audit

copy database from livedb to traindb using onload

Wouldn't that mean:
triggers on traindb --> live_audit ??

Is there a process somewhere that disables the triggers that isn't
working, perhaps??

JWC

JWC

Well that might be true but in the past when these scripts have been
run the triggers where not loaded or did not work or whatever.

I'm just trying to figure out what changed, the scripts have not been
changed since 04/03/2002, we have been on 9.4 since 04/01/2005 and
have run these scripts at least 4-5 times prior without this
happening.

John