Skip to main content

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
------------------------------

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
------------------------------