Hi All,
Query regarding replication:
We are aware there is an EXCLUDE_FILE config in repconfig which can be used to exclude a file but we are not looking to exclude all the records of that file instead just a single record of that file which is created every morning.
Kindly suggest if there is any way to do so.

------------------------------
Shubham Nigam
Rocket Forum Shared Account
------------------------------
Currently there is no configuarable in U2 Replication that will allow you to exclude an item within a replicated file.
------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------
Currently there is no configuarable in U2 Replication that will allow you to exclude an item within a replicated file.
------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------
For a completely Heath Robinson approach, you could redefine your file as a distributed file with this item in its own part file and don't replicate that part... (crazy but it's a Friday)
------------------------------
Brian Leach
Director
Brian Leach Consulting
Chipping Norton GB
------------------------------
For a completely Heath Robinson approach, you could redefine your file as a distributed file with this item in its own part file and don't replicate that part... (crazy but it's a Friday)
------------------------------
Brian Leach
Director
Brian Leach Consulting
Chipping Norton GB
------------------------------
Brian,
Another Heath-Robinson option would be to make the subscriber sub-writeable, allow triggers, and add a write trigger program that rejects writes for a specific record - but only on an active subscriber.
Regards
JJ
------------------------------
John Jenkins
Thame, Oxfordshire
------------------------------
Brian,
Another Heath-Robinson option would be to make the subscriber sub-writeable, allow triggers, and add a write trigger program that rejects writes for a specific record - but only on an active subscriber.
Regards
JJ
------------------------------
John Jenkins
Thame, Oxfordshire
------------------------------
There are potentail downsides to the trigger approach ...
You have to allow triggers to run for all the files in the replication group that you're one file is a member of ... you could of course have a replication group with only the one file in it to avoid this.
For each item that is disallowed via a trigger on the subscriber, an entry in the error logs will be generated.
------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------
Hi All,
Query regarding replication:
We are aware there is an EXCLUDE_FILE config in repconfig which can be used to exclude a file but we are not looking to exclude all the records of that file instead just a single record of that file which is created every morning.
Kindly suggest if there is any way to do so.

------------------------------
Shubham Nigam
Rocket Forum Shared Account
------------------------------
Thanks everyone for your suggestions.
There is a record in &UFD& which is causing us the issues while doing replication.
Can we just go ahead and exclude &UFD&. Will there be any impact on the system if we exclude &UFD&, please suggest.

------------------------------
Shubham Nigam
Rocket Forum Shared Account
------------------------------
Thanks everyone for your suggestions.
There is a record in &UFD& which is causing us the issues while doing replication.
Can we just go ahead and exclude &UFD&. Will there be any impact on the system if we exclude &UFD&, please suggest.

------------------------------
Shubham Nigam
Rocket Forum Shared Account
------------------------------
Hi Shubham,
By default, the &UFD& file is excluded for an account level group as defined in the repacct.def file.
# cat repacct.def | grep UFD
EXCLUDED_FILE=&UFD&
So I don't see any reason why excluding it would cause any issue. Was there a specific reason it was included in the first place?
Thanks,
Neil
------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------
Hi Shubham,
By default, the &UFD& file is excluded for an account level group as defined in the repacct.def file.
# cat repacct.def | grep UFD
EXCLUDED_FILE=&UFD&
So I don't see any reason why excluding it would cause any issue. Was there a specific reason it was included in the first place?
Thanks,
Neil
------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------
Hi Neil,
Looks like this is commented out in our repacct.def file. We would probably exclude this. Thanks!
------------------------------
Shubham Nigam
Rocket Forum Shared Account
------------------------------