onunload/onload & trigger audit
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