Return
-
Title
SharePlex replication to FILE category and how to control frequent file switch. -
Description
How to control frequent file switch when replicating to FILE category using SharePlex.
-
Cause
With default property values, file switch happens very frequently. Huge number of smaller files will be created. -
Resolution
File switch can be controlled using below properties.max_records=number Maximum size of the active file, measured by the number of records, before switching files.Default value 50,000Ex:sp_ctrl> target x.file queue <queue_name> set file max_records=200000Restart post process.max_size=megabytes Maximum size of the file, measured in megabytes, before switching files.Default value 50Ex:sp_ctrl> target x.file queue <queue_name> set file max_size=4096Restart post process.max_time=seconds Maximum number of seconds to wait before switching files.Default value 300Ex:sp_ctrl> target x.file queue <queue_name> set file max_time=1800Restart post process.These three properties values are required for to restrict file switching. File switch can happen on any of the above value met and it is not possible to set unlimited.Note: A single big transaction writes only to active file alone until it receives commit.